divide by 1,000 like in Excel

[qwertyjjj]

Hi
In Excel, I believe you can format a number and automatically divide it by 1,000 without messing up rounding.
For example, 10,000.06 after you apply the formatting becomes 10 as in 10k (for some reason accounting people find this easier to look at/work with). However, if you try to sum the value Excel will actually use the decimal figure rather than the number 10.

Is there a similar way in Access?

 

[qwertyjjj]

bump......

 

[Len Boorman]

Think if you divide by 1000 and set the number as Double or similar and set number of decimals to 0 then the actual number incly decimal points is stored and therefore considered in calculations but the display is as required.

L