A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cell converts a date entry to "=" and displays "01/00/00



 
 
Thread Tools Display Modes
  #1  
Old April 8th, 2005, 02:25 PM
##
external usenet poster
 
Posts: n/a
Default 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  
Old April 8th, 2005, 02:51 PM
bj
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:42 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.