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" 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 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 > 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?