Number Format Issue

  • Thread starter Thread starter Paul Axelrod
  • Start date Start date
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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing zip code to number 3
Paste Special Formula Multiply feature doesn't work anymore 2
Conditional Formatting 2
Remove date format? 3
problem with "average" function 4
Removing ' from a lotus file 1
yearfrac format error? 4
Formatting not applied until cell is edited 2

Back
Top