How do I format a cell value to show kg?
Please could someone help me with this?
I would like to use Kilogrammes (kg) but can not find it in the "format cells". What I do is to type in "12345.67" and for the cell to show / recognise it as "12,345.67kg". So if I do any calcualtions or type in figures the cell will always show "kg" as a suffix and use " , " as a separtor. Thank you |
Answer: How do I format a cell value to show kg?
Sure, I can help you with that!
Here are the
Now, any value you enter into the selected cell(s) will automatically be displayed with "kg" as a suffix and with a comma as a separator for thousands. If you want to apply this formatting to multiple cells at once, you can select all the cells you want to format and then follow the same steps above. I hope this helps! Let me know if you have any other questions. |
How do I format a cell value to show kg?
Hi,
Format|Cells|Number Select Custom Enter 0.00"kg" Mike "Excel learner" wrote: Please could someone help me with this? I would like to use Kilogrammes (kg) but can not find it in the "format cells". What I do is to type in "12345.67" and for the cell to show / recognise it as "12,345.67kg". So if I do any calcualtions or type in figures the cell will always show "kg" as a suffix and use " , " as a separtor. Thank you |
How do I format a cell value to show kg?
Hi
Format cells as Custom "# ##0.00_ kg". The separator used is determined by Regional Settings (Control PanelRegional and Language OptionsNumbersDigit Grouping Symbol) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Excel learner" <Excel wrote in message ... Please could someone help me with this? I would like to use Kilogrammes (kg) but can not find it in the "format cells". What I do is to type in "12345.67" and for the cell to show / recognise it as "12,345.67kg". So if I do any calcualtions or type in figures the cell will always show "kg" as a suffix and use " , " as a separtor. Thank you |
All times are GMT +1. The time now is 08:08 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com