Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bev
 
Posts: n/a
Default Inserting a number and having it displayed as you typed

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   Report Post  
Anne Troy
 
Posts: n/a
Default

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   Report Post  
Gary's Student
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"