ExcelBanter - my excel change data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - my excel change data (https://www.excelbanter.com/excel-discussion-misc-queries/169625-my-excel-change-data.html)

Mohamed

my excel change data

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

Bob I

my excel change data

Put an apostrophe in front of the characters. Excel only maintains 15
digits of precision for true numbers.

Mohamed wrote:

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

All times are GMT +1. The time now is 03:14 PM.