format change on Copy sheet

[Glenn]

Help needed!

I am getting data format corruptions on move or copying a
sheet. My sheet has data, as chart and some formulas.
After Copyig a sheet dat formats display like # #### ####
and change to left justified including on some other
sheets that have nothing to do with what I am doing.

How can this happen? How can I prevent it.
I could like to email someone the file to take a look at.

Glenn

 

[Earl Kiosterud]

Glenn,

It sounds as if you're selecting cells, and copy/pasting. Maybe copying the
entire sheet would do better. Right-click the sheet tab, Move or Copy, etc.

If your formulas refer to stuff outside the sheet, they won't work.

 

[glenn]

This was what happened using Move or Copy sheet
I think that something is going wrong in EXcel

-----Original Message-----
Glenn,

It sounds as if you're selecting cells, and

copy/pasting. Maybe copying the