Format cells wont let me "0.00 g"
 

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.

Format cells wont let me "0.00 g"
 

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566799

Format cells wont let me "0.00 g"
 

Use either

0.00 "g"

or

0.00 \g


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=566799