If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cell converts a date entry to "=" and displays "01/00/00
A spreadsheet previously created changes a date entry to "=date typed in" and
displays "01/00/00" no matter what format has been applied to the cell. |
#2
|
|||
|
|||
Check in viewnamesdefine to see if there is a named cell called "date
typed in". Are there underscores or anything between the words? I get an error message when I put your equation in a cell and a "can't do it" note when I try to name a cell "date typed in" I can't make it display "01/00/00". "##" wrote: A spreadsheet previously created changes a date entry to "=date typed in" and displays "01/00/00" no matter what format has been applied to the cell. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cell displays formula and not result | Ettienne | General Discussion | 5 | June 5th, 2005 10:01 PM |
creating new calendar item displays incorrect date | bkw | Calendar | 1 | April 4th, 2005 08:05 PM |
Date displays in arabic? lettering | mcr | General Discussion | 1 | June 22nd, 2004 07:11 AM |
Date Displays as 1/1/1904 | bluesband | General Discussion | 2 | June 22nd, 2004 01:06 AM |
Default display of sample date in linked workbook with blank date in source cell | Barbara Martens | Worksheet Functions | 2 | April 15th, 2004 10:15 PM |