Is there a way, without changing settings in toold_options_calculations, to get a displayed value to be used rather than the cell value?
The cell value in A1 is 2.001475
The displayed value is 2.001 as it is rounded that way.
In cell A2 is a reference number, in this case simply 2.0
Cell A3 is to show the difference between A1 and A2 after being multiplied by 1000.
So Cell A3 should show 1 (rather than 0.001).
What I'm getting however is the cell value rather than what it would be displayed (so I'm getting 1.475 instead of 1).
I know you can change the settings of excel to calculate dsiplayed values, but I don't want to do it for all cells - just certain ones.
Also the number of decimal places of A1 will vary so I can't just set cell A3 to a specific number of places.
Bookmarks