format change on Copy sheet

G

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
 
E

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.
 
G

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
Click to expand...
copy/pasting. Maybe copying the
 
Top