![]() |
Wy is Excel automatically rounding my sums?
I can't figure out how to make it display the actual sum. The formula
doesn't show any kind of roundup function in it. Has anyone dealt with this already? |
Wy is Excel automatically rounding my sums?
FormatCellsNumberGeneral.
Widen your column. -- Kind regards, Niek Otten "Rocha" wrote in message ... I can't figure out how to make it display the actual sum. The formula doesn't show any kind of roundup function in it. Has anyone dealt with this already? |
Wy is Excel automatically rounding my sums?
Hi,
See whether the following helps: Select the cell(s) and rightclick -- "Format Cells" -- check "Number" under "Category" in the "Number" Tab, and set the "Decimal Places" as you wish -- "OK" Regards, B. R. Ramachandran "Rocha" wrote: I can't figure out how to make it display the actual sum. The formula doesn't show any kind of roundup function in it. Has anyone dealt with this already? |
All times are GMT +1. The time now is 05:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com