View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default cell format for date/time in same cell excel 2003

Hmmm, I'm running Excel 2003 SP1 and have combined date/time formats
available under both the Date and Time categories under Format Cells, on
the Number tab. If you're not able to get it that way, perhaps you can use a
Custom format: [$-409]m/d/yy h:mm AM/PM;@
That's what shows up when I first select a date/time format and then choose
a custom format...
--Bruce

"Sandy" wrote:

excel 2003 does not offer a combined date/time in one cell in the "cell
format" pulldown. 95 and 97 did.
I download massive amounts of data from a data logger in coma delim (csv)
format, but 2003 will only display the time OR the date

Help

Sandy