If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Setting special format for a cell
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Setting special format for a cell
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 |
#5
|
|||
|
|||
Setting special format for a cell
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 . |
#6
|
|||
|
|||
Setting special format for a cell
1. Highlight the column by clicking on its heading (eg, the "A")
2. Right-click on any highlighted cell 3. Choose Format Cells... 4. Choose Custom 5. In the Type: box, copy and paste the following: 0" m²" 6. Click OK Now enter your numbers in that column. Regards, Fred "Ruslan" wrote in message ... 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 . |
#7
|
|||
|
|||
Setting special format for a cell
In Custom dialog type 0" m
Then hold down Alt key and on the numpad type 0178 Then type the final " Or run this macro on selected cells. Sub sq_Meters() Selection.NumberFormat = "0"" m" & Chr(178) & """" '0179 for cubic meters End Sub Gord On Sun, 14 Mar 2010 14:41:01 -0700, Ruslan wrote: 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 . |
Thread Tools | |
Display Modes | |
|
|