View Single Post
  #2  
Old March 14th, 2010, 05:38 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
 
Posts: 489
Default Setting special format for a cell

Custom Format (FormatCellsCustom) of 0" sq.m." (including the quotes)

--

HTH

Bob

"Ruslan" wrote in message
...
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