my excel change data

  • Thread starter Thread starter Mohamed
  • Start date Start date
M

Mohamed

i am typing the following number 8920033000001887773 then enter and it
becomes 8920033000001880000 I don't know why but i tried to change format
cells but nothing knew
 
Put an apostrophe in front of the characters. Excel only maintains 15
digits of precision for true numbers.
 
You must log in or register to reply here.

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

Default number format in Excel 1
Entering 'GTi' but I get 'Gti' ! 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel Highlighting duplicates 0
How to STOP Excel from changing my data 1
Why does excel replace my 16th number with a zero? 2
retain custom date format "text" when pasting or reformatting data 2
Overlapping Cells 4

Back
Top