Computing.Net > Forums > Office Software > Excel Date Question

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Excel Date Question

Reply to Message Icon

Name: Old Salt
Date: April 29, 2004 at 06:19:22 Pacific
OS: Win 98 se
CPU/Ram: 800/256
Comment:

On one of my spreadsheets in excel (word 2k Pro) the date has changed to string of numbers, if I select the cell the correct date displays in the formula bar, how can I get the date to display?
I tried to format the cell/s to custom DD'MM'YY and even DD MMM YY but no change??
I must have changed something, but what....

Thanks in advance for your response and avagoodweekend.



Sponsored Link
Ads by Google

Response Number 1
Name: chnos
Date: April 29, 2004 at 07:57:05 Pacific
Reply:

it happens when u choose "display formula" in options/display...maybe u've done it..?


0

Response Number 2
Name: Old Salt
Date: April 30, 2004 at 04:17:30 Pacific
Reply:

Thank You Taxi, problem fixed.

May you live long and prosper........


0

Response Number 3
Name: chnos
Date: May 2, 2004 at 08:53:19 Pacific
Reply:

same 4 U old boy...


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Excel Date Question

Excel date format question www.computing.net/answers/office/excel-date-format-question/6376.html

Excel Date Formula - Help?! ;( www.computing.net/answers/office/excel-date-formula-help-/1243.html

Excel date format www.computing.net/answers/office/excel-date-format/1516.html