Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I suppress the time in m/d/yy date column?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I suppress the time in m/d/yy date column?
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... -- HTH... Jim Thomlinson "hbrad" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
suppress printing a repeating value in a column | Excel Discussion (Misc queries) | |||
combine date one column, with time another column into third? | Excel Worksheet Functions | |||
Excel: Add time to a date and time column? | Excel Worksheet Functions | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions |