Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2003. I'm entering data into a spreadsheet that has the date as the
first column. It worked fine for 50 columns, using the 01-Mar-06 date format. Suddenly in column 51, after entering the next date (11 May 06) and pressing tab to move to the next column, the date displayed as "#########" instead of "11-May-06." I tried re-formatting the one cell and the entire column. The correctly-displayed dates through column 50 still looked good, but no matter what I tried from the formatting menu column 51 and later return the multiple number signs instead of a date. What's up? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) |