I've done some failry extensive looking for variations on the "," format
code theme, and haven't found much. Best answer would depend a lot on
your overall goals. Maybe some variation on this theme:

Place the "real" values in column 1
Column 2 then contains the formula =A1/10^n where n is the number of
places you want the decimal moved.

Calculations that need to reference the real values will reference
column 1, and tables/reports that need to reference the displayed
values will reference column 2. I know that the apparent redundancy
seems irritating, but it's probably the simplest way to get what you
want.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=479414