Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I get unexpected results when date formatting a worksheet cell in a MS Excel
spreadsheet - in other words it looks like a calculation is trying to take place such that entering 1220 in the cell returns a date of 5/4/1903 and entering 12202006 0r 122006 returns a negative date displayed as ########. I have not experienced something like that before and I use MS Excel way too much! The cells are formatted as dates. Is there a way I can enter the dates without the slashes? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format of Cell an Issue | Excel Worksheet Functions | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell data format | Excel Discussion (Misc queries) | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |