N
Nabil
i need to format cells with weight, similar like one can format with
currency. is there such a thing.
currency. is there such a thing.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi,
You can apply a custom format of
#" oz"
or
"oz "#
or
"Ounces "#
Mike
You can apply a custom format of
#" oz"
or
"oz "#
or
"Ounces "#
Mike
×
מיכ×ל (מיקי) ×בידן
Try custom format: # "oz."
Micky
Micky
T
trip_to_tokyo
Just in case you don’t know how to make a custom format (this is in EXCEL
2007 but I think earlier versions work the same way):-
1. Click in cell A 11 (for example).
- Home
- Font group, click on the arrow in the lower right hand corner
- Format Cells should launch
- Number tab
- click on Custom in the Category: list (on the left hand side). This will
highlight the word Custom
- the word General should now appear beneath the word Type: on the right
hand side
- delete the word General and replace it with:-
# "oz"
(that is a hash sign / then a space / then an open inverted comma / then oz
/ then close inverted comma)
- click OK
This will save the:-
oz
- setting for you.
2. Now, for example, highlight the range (this can be any range you like):-
F 13 to G 21
3. Then:-
- Home
- Font group, click on the arrow in the lower right hand corner
- Format Cells should launch
- Number tab
- click on Custom in the Category: list (on the left hand side). This will
highlight the word Custom
- now scroll down in the Type: field (on the right hand side) and at the
bottom of the list you should see the:-
# "oz"
- that you have just added.
4. Select it (by clicking it) and then hit OK.
5. Now the range:-
F 13 to G 21
- from number 2. above should have the oz format you require.
6. Test it by entering numbers in the specified range:-
F 13 to G 21
- and you should get oz appearing after the numbers that you have entered.
If my comments have helped please hit Yes.
Thanks.
2007 but I think earlier versions work the same way):-
1. Click in cell A 11 (for example).
- Home
- Font group, click on the arrow in the lower right hand corner
- Format Cells should launch
- Number tab
- click on Custom in the Category: list (on the left hand side). This will
highlight the word Custom
- the word General should now appear beneath the word Type: on the right
hand side
- delete the word General and replace it with:-
# "oz"
(that is a hash sign / then a space / then an open inverted comma / then oz
/ then close inverted comma)
- click OK
This will save the:-
oz
- setting for you.
2. Now, for example, highlight the range (this can be any range you like):-
F 13 to G 21
3. Then:-
- Home
- Font group, click on the arrow in the lower right hand corner
- Format Cells should launch
- Number tab
- click on Custom in the Category: list (on the left hand side). This will
highlight the word Custom
- now scroll down in the Type: field (on the right hand side) and at the
bottom of the list you should see the:-
# "oz"
- that you have just added.
4. Select it (by clicking it) and then hit OK.
5. Now the range:-
F 13 to G 21
- from number 2. above should have the oz format you require.
6. Test it by entering numbers in the specified range:-
F 13 to G 21
- and you should get oz appearing after the numbers that you have entered.
If my comments have helped please hit Yes.
Thanks.
×
מיכ×ל (מיקי) ×בידן
Wouldn't right clicking the cell > 'format...' be much easier - especially if
he is, at that moment, at some "deep" sub-menu within another Ribbon tab !?
Micky
he is, at that moment, at some "deep" sub-menu within another Ribbon tab !?
Micky
S
Sheeloo
Yes, that would be easier...
btw in Excel 2003 Format->Cells is easier to access.
CTRL-1 also works in both 2003 and 2007.
btw in Excel 2003 Format->Cells is easier to access.
CTRL-1 also works in both 2003 and 2007.