Setting special format for a cell
In Custom dialog type 0" m
Then hold down Alt key and on the numpad type 0178
Then type the final "
Or run this macro on selected cells.
Sub sq_Meters()
Selection.NumberFormat = "0"" m" & Chr(178) & """"
'0179 for cubic meters
End Sub
Gord
On Sun, 14 Mar 2010 14:41:01 -0700, Ruslan
wrote:
Dear Gord,
Sorry, but I didn't get the sequences of typing. Could you be more detailed.
since I'not so professional.
Rgds,
Ruslan
"Gord Dibben" wrote:
One more custom format.......
Type 0" m then Alt + 0178 then "
Gives 12 mē
Gord Dibben MS Excel MVP
On Sun, 14 Mar 2010 10:33:01 -0700, Ruslan
wrote:
Dear All,
Could you please tell me how can I can set special format to a column?
To be precise, I'd like to set such a format to the column of cells that it
always shows like " ... sq.m.". For example, if i enter number 5 to the
cell, it must then look like "5 sq.m".
Regards,
Ruslan
.
|