Format cells wont let me "0.00 g"

[Bruno]

I want format a column with a number value and the letter "g" following it. I
have already done this with Kt. value but for some reason the letter G
doesn't work. It says cannot use the number format you typed.

 

[VBA Noob]

Do you not just format it as 0.00"g" ??

VBA Noo

 

[daddylonglegs]

Use either

0.00 "g"

or

0.00 \