Home » Forums » Open Source Learning Center » Question and Answer

is it possible?

Submitted by batya on 9 February, 2012 - 12:56

when i write 12345678912345678912345 in a cell i got displayed this "1.23457E+22" or "12345678912345600000000.00". it shows zeros after 15th digit. so is it possible to make it display fully like i wrote in a first place. thanks in advance

‹ SUMPRODUCT with criteria to evaluate items greater than 1 as 1 Copy Data to other sheet with some conditions ›
»
Nick's picture

y.. before you enter the

Submitted by Nick on 9 February, 2012 - 13:38.

y.. before you enter the data

right click
format cells
choose: "text"

»

i got a lot of data

Submitted by batya on 9 February, 2012 - 13:53.

wow it worked.thanks.but...
i got a lot of data written and i want to change them all together. does this mean i have to re-write all numbers again?
thanks in advance

»
Nick's picture

if you have it written

Submitted by Nick on 9 February, 2012 - 14:15.

if you have it written already, Excel will have rounded it to 15 digits

If it's a formatting issue, try this:

right click on the column
format cells
number
0 decimal places

»

15th digit

Submitted by Anonymous on 9 February, 2012 - 14:34.

If i do like you said it shows only up to 15th digit, remaining digits automatically turns into "zeros".

»
Nick's picture

right, then the data is

Submitted by Nick on 9 February, 2012 - 15:04.

right, then the data is lost...

»

thanks

Submitted by batya on 9 February, 2012 - 18:05.

darn it! i appreciate your help Nick. Thank you very much

»
Nick's picture

if u edit your original post,

Submitted by Nick on 9 February, 2012 - 18:16.

if u edit your original post, and add an example file, I can tell u for sure

»