Hmm... I don't in XL04 (I tested first).


In article ,
Gord Dibben <gorddibbATshawDOTca wrote:

Found I had to add quotes in order to get this to work.

[=1000]#,##0, "Kg";0 "G"