Number in column cell in m²
Solved
brilou02
Posted messages
43
Status
Membre
-
brilou02 Posted messages 43 Status Membre -
brilou02 Posted messages 43 Status Membre -
Hello,
I am looking for how to format numbers in Excel (cell format, number) in m² just like you can do for currency, date, etc.
Thank you in advance.
Brilou
Configuration: Windows 7 / Firefox 16.0
I am looking for how to format numbers in Excel (cell format, number) in m² just like you can do for currency, date, etc.
Thank you in advance.
Brilou
Configuration: Windows 7 / Firefox 16.0
2 réponses
Hello,
there are many predefined formats in Excel for this, right-click on your cell or range of cells/Format Cells/Number and there choose your date, time, currency format, etc.
we often forget to check the Special category to display phone numbers for social security departments, etc.
but you can create your own format, like for square meters, just go to Custom and enter this format in the Type text box
0.00 " m²"
to make the 2 of square meters superscript, either use the key above the tab key or press Alt and 253 on the numeric keypad or Alt 252 for cubic meters
Best,
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
there are many predefined formats in Excel for this, right-click on your cell or range of cells/Format Cells/Number and there choose your date, time, currency format, etc.
we often forget to check the Special category to display phone numbers for social security departments, etc.
but you can create your own format, like for square meters, just go to Custom and enter this format in the Type text box
0.00 " m²"
to make the 2 of square meters superscript, either use the key above the tab key or press Alt and 253 on the numeric keypad or Alt 252 for cubic meters
Best,
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
