Numbers are changed in Excel?

  • Thread starter Thread starter Dejola
  • Start date Start date
D

Dejola

I created a spread sheet of some stuff. I entered some serial and
account numbers. For some reason that everyone but me probably knows
the numbers are changed by Excel by inserting a ., a + sign, etc. hat
are not as I typed.

What's going on here?

Thanks.
 
I would say it's some formatting (either default or pre-existing) in those cells.

Try giving all those cells the "Text" format. Then Excel won't add decimal places or signs. I -think- Excel won't let you do math with those values (unless you convert them first), but you probably don't need to add or subtract serial numbers or account numbers. :)

Mike
 
Select the cells then go to Format>Cells & select Number,0 Decimal Places.

In the future you can avoid the numbers being exponentially displayed if you
format the cells as Text before entering the data.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
Back
Top