Numbers are changed in Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dejola - 05 Nov 2006 02:59 GMT

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.

Reply to this Message

Broida (spamless) - 05 Nov 2006 03:16 GMT

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

> I created a spread sheet of some stuff. I entered some serial and
> account numbers. For some reason that everyone but me probably knows
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

CyberTaz - 05 Nov 2006 03:30 GMT

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

On 11/4/06 9:59 PM, in article
1162695574.279077.265500@e3g2000cwe.googlegroups.com, "Dejola"
<johnandjanet@gmail.com> wrote:

> I created a spread sheet of some stuff. I entered some serial and
> account numbers. For some reason that everyone but me probably knows
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message

Dejola - 05 Nov 2006 13:22 GMT

Thanks so much. Of course, I remember now.
I appreciate your speedy help.

> I created a spread sheet of some stuff. I entered some serial and
> account numbers. For some reason that everyone but me probably knows
[quoted text clipped - 4 lines]
>
> Thanks.

Reply to this Message