Home |
Search |
Today's Posts |
#1
|
|||
|
|||
format cells to Kg and g
Does anyone know how to format cells into Kg and G? Please.
|
#2
|
|||
|
|||
Not sure exactly what you're after, but perhaps
Format/Cells/Number/Custom [=1000]#,##0, Kg;0 G In article , "irishbird25800" wrote: Does anyone know how to format cells into Kg and G? Please. |
#3
|
|||
|
|||
J.E.
Found I had to add quotes in order to get this to work. [=1000]#,##0, "Kg";0 "G" Gord Dibben Excel MVP On Wed, 24 Nov 2004 15:51:24 -0700, JE McGimpsey wrote: Not sure exactly what you're after, but perhaps Format/Cells/Number/Custom [=1000]#,##0, Kg;0 G In article , "irishbird25800" wrote: Does anyone know how to format cells into Kg and G? Please. |
#4
|
|||
|
|||
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 On Wed, 24 Nov 2004 14:43:08 -0800, "irishbird25800" wrote: Does anyone know how to format cells into Kg and G? Please. |
#5
|
|||
|
|||
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" |
#6
|
|||
|
|||
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" |
#7
|
|||
|
|||
"Gord Dibben" <gorddibbATshawDOTca wrote...
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 .... 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. |
#8
|
|||
|
|||
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? In article , Gord Dibben <gorddibbATshawDOTca wrote: Just one of those things<g |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
how do you format a row of cells based upon a value in another ce. | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |