View Single Post
  #3  
Old March 14th, 2010, 05:39 PM posted to microsoft.public.excel.worksheet.functions
Mike H
external usenet poster
 
Posts: 8,419
Default Setting special format for a cell

Hi,

Select these cells then 'Right click' select 'Custom' and apply a custom
format of

0.00" Sq M"


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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