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

  • Thread starter Thread starter deva
  • Start date Start date
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
 
Enter them in cells preformatted as Text or with a leading apostrophe
(').

If this post helps click Yes
 
Enter them in cells preformatted as Text or with a leading apostrophe
(').

If this post helps click Yes
 
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?
 
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?
 

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
how do I calculate a running average? 1
how to continue writing in a single cell? 3
Displaying a 12-digit Number 4
Showing 18 digits or more in a cell 1
Image not displaying in datagridview column in vb.net 1
how to tell excel to read numeric field as character fr a csv file 3
Excell- am stupid and need help figuring out how to write in cell 2

Back
Top