| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a cell to a date format?
I am trying to format cells to date formats. Even after I go to Format
Cells and choose the DATE format, the cell does not display the date when I type it in. For example, I will type in 6/14/2003 and when I press enter the cell reads, 37786. The date does appear in the formula bar though. How can I fix this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I format a cell to a date format?
Hi Trainer,
try to delete de format EDIT | CLEAR | FORMAT and format it as a date again HTH regards from Brazil Marcelo "trainer07" escreveu: I am trying to format cells to date formats. Even after I go to Format Cells and choose the DATE format, the cell does not display the date when I type it in. For example, I will type in 6/14/2003 and when I press enter the cell reads, 37786. The date does appear in the formula bar though. How can I fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How I convert date formatt of dd/mm/yy to mm/yy (not cell format) | Excel Discussion (Misc queries) | |||
| run a macro in a locked cell | Excel Discussion (Misc queries) | |||
| date format and the RIGHT function | Excel Worksheet Functions | |||
| How to format cell with text and date. | Excel Discussion (Misc queries) | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Hybrid Mode
