Bob,
You are a star!

Thanks very much for this.
Regards
Colin
"Bob Phillips" wrote in message
...
0,"K"_);(0,"K)";0"K"_);@

--
HTH

Bob Phillips

"Colin Foster" wrote in message
...
Is there a simple way to use a custom format to scale a number.
For example, user inputs 12,000 & 12 k appears?

I'm fairly sure that I've done this in the past, but too much beer has
made
me forget!

Regards
Colin Foster