How about using a custom format of #,

"Peters" wrote:

Hello,

When working with budgeting in Excel 2003, my colleauges normally write
values without prefix on the currency, for example 1.500.000 SEK (Swedish En
Krona). When consolidating the budget, I prefer to display the values in kSEK
(kilo Swedish En Krona). I could do this by making a new spreadsheet and
dividing with 1000, but it does not feel like the right solution. If you can
use percentage formatting of cells, you should be able to do the same with
SEK and kSEK or USD and MUSD? But how?

Thanks in advance,
Peter