How do I suppress the time in m/d/yy date column?

H

hbrad

When displaying the date (m/d/yy) in an Excel worksheet through a graphing
tool, the time stamp of 12:00:00 is coming over. How do I suppress that?
 
J

Jim Thomlinson

What do you mean using a graphing tool??? Which tool??? In XL dates are
ultimately stored as plain numbers. For example todays date at 12:49 in the
afternoon is stored as 39699.5340861111

39,699 is the number of days since Jan 1 1900 (not entirely true but good
enough for this discussion)

..5340861111 is the time. We are just a little more than half way though the
day. If you get rid of the decimal then you are at midnight... You do not
indicate if your 12:00 is am or pm which would mean 0 or .5 was being passed
to the graphing tool...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Macro Not Executing - Need Help 1
Accessibilty - how to open doc with keyboard? 0
Excel 2002 date entry: Cannot get away from d-m-yy entry format 3
Pivot Table date format 1
separating date and time 5
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Calculate the amount of time over a permitted amount (12 hours) 9
Weird date format problem 2

Top