| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting decimal place for each row in a column
I have Excel 2003. I a column containing 30 rows. I would like the numbers in
each row of the column to be to two decimal places, i.e., xxx.yy. I am currently in row 2 of the column. What do I do to automatically general number to two decimal places in the remaining 28 rows? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Setting decimal place for each row in a column
Select the column
Format/ Cells/ Number/ 2 places -- David Biddulph "jfg" wrote in message ... I have Excel 2003. I a column containing 30 rows. I would like the numbers in each row of the column to be to two decimal places, i.e., xxx.yy. I am currently in row 2 of the column. What do I do to automatically general number to two decimal places in the remaining 28 rows? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Setting decimal place for each row in a column
Thanks, David.
"David Biddulph" wrote: Select the column Format/ Cells/ Number/ 2 places -- David Biddulph "jfg" wrote in message ... I have Excel 2003. I a column containing 30 rows. I would like the numbers in each row of the column to be to two decimal places, i.e., xxx.yy. I am currently in row 2 of the column. What do I do to automatically general number to two decimal places in the remaining 28 rows? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count first decimal place only | Excel Discussion (Misc queries) | |||
| Decimal place formatting | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| changing to two place decimal | Excel Worksheet Functions | |||
Linear Mode
