ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Numbers turning to Zero's (https://www.excelbanter.com/excel-discussion-misc-queries/75249-numbers-turning-zeros.html)

DaveG

Numbers turning to Zero's
 
Hello,
I am trying to place a large number (19 digits), into a cell, I do this, but
when I leave the cell the last four digits turn to zero's. Why?

Can anyone help, please.

When i go into format cell's the General shows the number in the following
format (*.*****E+13), this dosen't look right either, is it?


Numbers turning to Zero's
 
See answer in public.misc and please don't multipost.

Andy.

"DaveG" wrote in message
...
Hello,
I am trying to place a large number (19 digits), into a cell, I do this,
but
when I leave the cell the last four digits turn to zero's. Why?

Can anyone help, please.

When i go into format cell's the General shows the number in the following
format (*.*****E+13), this dosen't look right either, is it?





All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com