cell format for date/time in same cell excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

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

Peculiar default cell format 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
separating date and time 5
Merge cells time format 4
Conditional Formatting Date Range 2
setting cell values based on a 3rd cell 4
all cells in 2 workbooks have automaticlly changed to date format 1
Excel 2003 make 1 date cell automatically change another date cell 3

Back
Top