![]() |
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