Inserting a number and having it displayed as you typed

[Bev]

Want to insert a number in one cell of a worksheet and have it displayed as
such. However it either rounds the number off or inserts a decimal point.
I do not want this number for any mathematical function. I am inserting a
P.O. # for simply reference sake

[Anne Troy]

First format the column or cell or row as text using Format-->Cells, Number
tab.
************
Anne Troy
www.OfficeArticles.com

"Bev" <[email protected]> wrote in message
news:[email protected]...
> Want to insert a number in one cell of a worksheet and have it displayed
> as
> such. However it either rounds the number off or inserts a decimal
> point.
> I do not want this number for any mathematical function. I am inserting a
> P.O. # for simply reference sake
>

[Gary's Student]

Format the cell as text before entering the number
--
Gary's Student


"Bev" wrote:

> Want to insert a number in one cell of a worksheet and have it displayed as
> such. However it either rounds the number off or inserts a decimal point.
> I do not want this number for any mathematical function. I am inserting a
> P.O. # for simply reference sake
>