Prev: Why does it display #### in my cell?
Next: Lookup for this?
From: Ruslan on 14 Mar 2010 13:33
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
From: Bob Phillips on 14 Mar 2010 13:38
Custom Format (Format>Cells>Custom) of 0" sq.m." (including the quotes)

--

HTH

Bob

"Ruslan" <Ruslan(a)discussions.microsoft.com> wrote in message
news:4730007F-6A91-4F96-A8A0-E59B4644E9DE(a)microsoft.com...
> 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


From: Mike H on 14 Mar 2010 13:39
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
From: Gord Dibben on 14 Mar 2010 15:29
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
<Ruslan(a)discussions.microsoft.com> 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

From: Ruslan on 14 Mar 2010 17:41
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
> <Ruslan(a)discussions.microsoft.com> 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
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: Why does it display #### in my cell?
Next: Lookup for this?