| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell format for date/time in same cell excel 2003
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 row height format | Excel Discussion (Misc queries) | |||
| Excel 2003 to 95 File format conversion | Excel Discussion (Misc queries) | |||
| Excel 2003, It wont print in landscape format | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
Hybrid Mode
