Number Format Issue

P

Paul Axelrod

It seems that from time to time, some of our numbers get into Excel
2002 as text and will not sort properly. I know how to fix, by using
the Multiply feature in Paste Special to multiply all the offending
numbers by 1.
The question is, what causes this to occur when we start out with the
General format, and certainly do not format the cells as text?

Thanks in advance
 
M

Mark E. Philpot

Hi,

Do you paste anything into the sheet? Do you copy from one
sheet to another? Do you imprt or get external data into
this sheet?
 
Top