Display a number of significant digits

  • Thread starter Thread starter SWSW
  • Start date Start date
S

SWSW

Hi,

I would like to know how to display a number with more
than 15 digits. I tried to display a number with 18
digits, but the last three digits always appear as 000.

Thanks.
 
Format the cell as text first or precede your entry with an apostrophe. Both of
these enter the data as text.

'123412341234123412

will have all the digits show up.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

significant digits 20
News Bank of England considers digital currency 4
numbers convert to formula in csv 1
18 digit number 2
Two digit number with one decimal, or three digit number 2
How to round & sum only the displayed (rounded) numbers 2
Vlookup when lookup criteria is not an exact match 2
I need to add spaces to the beginning of my texts which are numbers 1

Back
Top