Excel 2003 showing diferrent info from 2000

[Dj_Arioch]

I have just purchased a new pc with Office 2003. My old pc was runnin
Office 2000. When I open an excel doc in 2003 some of the data i
missing and in it's place are #######'s. The data that is missing is i
date form, ex. 3/29/2004. When I open the data in 2000 again it appear
normal. It is in a lot of data or I would just rewrite it. Why is thi
happening and can I fix it

 

[Jim Rech]

The data is probably not gone. You just need to widen the columns a bit.
The fonts may be a little different than on your old PC.

--
Jim Rech
Excel MVP
|I have just purchased a new pc with Office 2003. My old pc was running
| Office 2000. When I open an excel doc in 2003 some of the data is
| missing and in it's place are #######'s. The data that is missing is in
| date form, ex. 3/29/2004. When I open the data in 2000 again it appears
| normal. It is in a lot of data or I would just rewrite it. Why is this
| happening and can I fix it?
|
|
| ---
| Message posted
|

 

[kkknie]

Hopefully, the ####### is just Excel's way of saying that the date i
too big to fit in the current column width. If you increase the widt
of the column does it show the date?

 

[Dj_Arioch]

Thanks. That was it. I'm a network guy not a software guy. Thanks fo
posting the reply so quickly

 

[Ken Wright]

Only other option I can think of is that the date may be the result of a formula
that requires the Analysis Toolpak which you probably don't yet have installed,
in which case it would be Tools / Addins / check Analysis Toolpak

 

[Dave Peterson]

You may want to look at
windows start button|settings|control panel|regional settings applet
date tab

and set the short date the way you want it.

I'm guessing that one format was m/d/yy and one is m/d/yyyy (or something
wider).