format cells to Kg and g

J

JE McGimpsey

Not sure exactly what you're after, but perhaps

Format/Cells/Number/Custom [>=1000]#,##0, Kg;0 G
 
G

Gord Dibben

J.E.

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

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

Gord Dibben Excel MVP

Not sure exactly what you're after, but perhaps

Format/Cells/Number/Custom [>=1000]#,##0, Kg;0 G



irishbird25800 said:
Does anyone know how to format cells into Kg and G? Please.
Click to expand...
Click to expand...
 
G

Gord Dibben

Format or "Convert"

J.E. gave you a format.

To convert from Imperial to Metric use the CONVERT Function which is accessed
from the Analysis Toolpak add-in.

Gord Dibben Excel MVP
 
G

Gord Dibben

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

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


Gord Dibben said:
Found I had to add quotes in order to get this to work.

[>=1000]#,##0, "Kg";0 "G"
Click to expand...
Click to expand...
 
H

Harlan Grove

Gord Dibben said:
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
Click to expand...
....

And under XL2K don't need the quotes.

Hard to imagine this is anything other than a bug in the later versions,
unless it's related to later Excel versions' Oh-so-wonderful ability to
parse muslim calendar dates under English language settings.
 
J

JE McGimpsey

I have a vague recollection that "g" is used in time or date formats in
certain international versions. Perhaps your versions is just more
cosmopolitan than mine?
 
Top