Number in column cell in m²
Solved
brilou02
Posted messages
43
Status
Member
-
brilou02 Posted messages 43 Status Member -
brilou02 Posted messages 43 Status Member -
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
Related links:
- Excel:Same number of digits in a column
- How to have 4 digits in a cell regardless of the number
- [Excel] Check if cells in column A exist in column C
- formula for number of lines in a cell
- Conversion de cellule avec le mois en chiffres en mois en lettres
- Increment numbers in cells of column based on a filter
2 answers
-
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. -