Excel 2002 on a PC here.

Also tested on 2003. Need the quotes.

Tested on 97. Don't need the quotes.

Just one of those things<g

Gord

On Wed, 24 Nov 2004 16:50:58 -0700, JE McGimpsey wrote:

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"