Please give me any suggestion

Microsoft Office 2000 professional
October 7, 2009 at 21:31:19
Specs: Windows XP
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?


See More: Please give me any suggestion

Report •


#1
October 7, 2009 at 21:48:14
Pls reply my suggestion

Report •

#2
October 8, 2009 at 04:00:37
Excel questions are best asked in the Office Software forum.

But,

Try formatting the cell as Date.

Task Bar
Format
Cell
Select Date
Select how you wish to display the Date
Click OK

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question