General Text format automatically get changed to DATE

[Shweta Srivastava]

I am using Excel (Office 2007). While working on a workbook everything is ok
however when I try to reopen it after saving all the data stored in General
gets chaged to Date type automatically.

Please help me undestand why this is happening? I have already loaded 2007
again as I thaught may be Excel got corrupted but still the issue remains the
same.

 

[Simon Lloyd]

Can you give an example of the data you're entering

I am using Excel (Office 2007). While working on a workbook everythin
is o
however when I try to reopen it after saving all the data stored i
Genera
gets chaged to Date type automatically

Please help me undestand why this is happening? I have already loade
200
again as I thaught may be Excel got corrupted but still the issu
remains th
same

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[Shweta Srivastava]

Hi Simon,
Thanks for your conceran.

For example if I maintain count of responses received under category Good,
Average & Poor and enter no. of counts in it (2,3,5) after saving the file
and reopening the same automatically the cells are set to DATE format and
instead of numbers it gives me date.

I hope am able to elaborate my query now.

Regards,
Shweta