D
deva
when i m writing 123456789123456789 in a cell. it is getting changed into
1.23457E+17. why? i want to write it without any change
1.23457E+17. why? i want to write it without any change
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
Juat type an apostrophe (single quote ) before your digits.
M
Mike H
Hi,
pre-format as text or enter an apostrophe ' before you type the number.
Mike
pre-format as text or enter an apostrophe ' before you type the number.
Mike
T
Trev B
You could format the cell as a Number with the correct no of Decimal Places
Trev B
Trev B
J
Jacob Skaria
Enter them in cells preformatted as Text or with a leading apostrophe
(').
If this post helps click Yes
(').
If this post helps click Yes
D
David Biddulph
So what number of decimal places do you think will display 18 significant
figures? Or are you using some new version of Excel which doesn't have the
limit of 15 significant figures?
figures? Or are you using some new version of Excel which doesn't have the
limit of 15 significant figures?