NEED #s TO BE DISPLAYED AS TYPED!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Determined07 - 17 Aug 2007 16:12 GMT

I'm attempting to type in a number and it is headed by 3 zeros. Excel keeps
converting to whole numbers. I need the number to be displayed exactly as I
typed it. Thanks in advance.

Reply to this Message

Peo Sjoblom - 17 Aug 2007 16:17 GMT

Format the cells as text before you type or precede the entry with an
apostrophe
If the number of digits are always the same you can use a custom format like

000000

for 6 digits

Signature

Regards,

Peo Sjoblom

> I'm attempting to type in a number and it is headed by 3 zeros. Excel
> keeps
> converting to whole numbers. I need the number to be displayed exactly as
> I
> typed it. Thanks in advance.

Reply to this Message

Determined07 - 17 Aug 2007 16:46 GMT

thanks. I right clicked, went to format cells, number-custom-000, and it's
still not allowing me to display as typed. all the cells will be uniform 000
with varying #s to follow. What am i doing wrong?

> Format the cells as text before you type or precede the entry with an
> apostrophe
[quoted text clipped - 9 lines]
> > I
> > typed it. Thanks in advance.

Reply to this Message

Determined07 - 17 Aug 2007 16:48 GMT

thank you! the apostrophe worked just fine. i'm making things more
complicated than they have to be i suppose, lol.

> Format the cells as text before you type or precede the entry with an
> apostrophe
[quoted text clipped - 9 lines]
> > I
> > typed it. Thanks in advance.

Reply to this Message