View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default number 12 digits to 15 digits

But if you do it that way, many functions will not treat it as a number, and
will ignore it.
--
David Biddulph

"Ms-Exl-Learner" wrote in message
...
Just format the cell as Text and try to enter the value.

Select the range and do Right Click and select Format
CellsNumberCategoryText and give ok.

Otherwise before entering the value in a cell type ' and enter the
numbers.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"mehdy-e" wrote:

How can i use number more than 12 digit without rounding?I want to show
for
examples exactly this number 1234567891234