View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
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