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!