I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable.

deva · May 14, 2009

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

Gary''s Student · May 14, 2009

Juat type an apostrophe (single quote ) before your digits.

Mike H · May 14, 2009

Hi,

pre-format as text or enter an apostrophe ' before you type the number.

Mike

Trev B · May 14, 2009

You could format the cell as a Number with the correct no of Decimal Places

Trev B

Jacob Skaria · May 14, 2009

Enter them in cells preformatted as Text or with a leading apostrophe
(').

If this post helps click Yes

David Biddulph · May 14, 2009

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?

Why does Excel replace any digits beyond 15 with zeros?	2	Mar 13, 2008
VBA word change keys	0	Mar 12, 2022
Can't save my Office documents (after computer rebuild and reauthorization)	0	Jun 10, 2022
how do I calculate a running average?	1	Apr 30, 2010
Cell Number Format	1	Jun 4, 2004
how to continue writing in a single cell?	3	Mar 3, 2010
highlighting only the currently selected cell, until i click off o	4	Sep 22, 2009
Complicated Formula Problem	10	Feb 18, 2014

I WANT TO WRITE 18 DIGITS FIGURE IN A SINGLE CELL. bu i m unable.

deva

Gary''s Student

Mike H

Trev B

Jacob Skaria

David Biddulph

Ask a Question

Similar Threads