Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
First format the column or cell or row as text using Format--Cells, Number
tab. :) ************ Anne Troy www.OfficeArticles.com "Bev" wrote in message ... 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 |
#3
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|