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

  • Thread starter Thread starter hbrad
  • Start date Start date
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?
 
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...
 
Back
Top