View Single Post
  #4  
Old March 14th, 2010, 07:29 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Setting special format for a cell

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