Format decimal point in cells

[Tweenieleenie]

Hi,

New to the forum so please accept my apologies if I haven't used correct jargon.

I am trying to insert a number in a cell that has 8 decimal places spot then 10 decimal places. i.e. 62105000.2000210104, excel keeps changing this to 62105000.200021000. I have tried customising the figures and also using # but excel keeps replacing the last four digits zero's.. Help Please?
[TABLE="width: 147"]
<colgroup><col width="196" style="width: 147pt; mso-width-source: userset; mso-width-alt: 7168;"> <tbody>[TR]
[TD="class: xl64, width: 196, bgcolor: transparent, align: right"]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

Hi,

New to the forum so please accept my apologies if I haven't used correct jargon.

I am trying to insert a number in a cell that has 8 decimal places spot then 10 decimal places. i.e. 62105000.2000210104, excel keeps changing this to 62105000.200021000. I have tried customising the figures and also using # but excel keeps replacing the last four digits zero's.. Help Please?
[TABLE="width: 147"]
<colgroup><col width="196" style="width: 147pt; mso-width-source: userset; mso-width-alt: 7168;"> <tbody>[TR]
[TD="class: xl64, width: 196, bgcolor: transparent, align: right"]
[/TD]
[/TR]
</tbody>[/TABLE]

Excel cannot display that many digits in a real number. I am guessing your "number" is not going to be used in mathematical calculations. If that is correct, simply format your cell as Text before putting your "number" into it. Alternately, you can leave the cell's format as General by typing an apostrophe (') first and then follow that with your "number".

 

[Joe4]

Welcome to the Board!

Does it need to be entered as a number? I don't think Excel can remember/store that many significant digits in a single number.
If you change the format of the cell to Text, you should to type the whole thing out and it won't change anything.

 

[Tweenieleenie]

Thank you both, changed to text and it's keeping the format. I will keep it as text going forward as I only need to be able to read the cell.

 

[Joe4]

You are welcome.

I will keep it as text going forward as I only need to be able to read the cell.

Yes, as long as you aren't using it in any sort of mathematical computation, that is the best way to go!