E
evon
I had use format cell to change my cell display for a number that round to
the nearest thousand.
i.e. if i input a number 123,456, i use format cell to make it display as
123.5
If i put seperate 2 cell for 123,456 so it will display as 123.5 & 123.5
when i make the sum for these 2 cell it will show the sum amount is 247.0.
Is there any way to make the sum become (123,456+123,456) = 246,912 which in
my cell format and show 246.9?
Please help. Thanks!
the nearest thousand.
i.e. if i input a number 123,456, i use format cell to make it display as
123.5
If i put seperate 2 cell for 123,456 so it will display as 123.5 & 123.5
when i make the sum for these 2 cell it will show the sum amount is 247.0.
Is there any way to make the sum become (123,456+123,456) = 246,912 which in
my cell format and show 246.9?
Please help. Thanks!