I enter 123456789123456789, this displays as 123456789123456000

G

gvn

I am unable to enter 123456789123456789 as this displays as
123456789123456000 which is incorrect. any thoughts
 
J

Jonathan Cooper

I know from a pervious discussion with Frank Kabel, that Excel only handles
up to 15 digits. If you describe your problem though, maybe there is another
solution.
 
D

Dave Peterson

Preformat the cell as text
or start with a leading apostrophe '123456789123456789

But then the value will be text--not a number.
 

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

Why does Excel replace any digits beyond 15 with zeros? 2
Entering Large Number 8
I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable. 5
Cell Number Format 1
How do I keep Excel from dropping my numbers to 0 after 15 digits 1
MAXIMUM NUMBERS IN CELL 1
Can I get a number in such a format as it should be? 3
Split form 0

Top