![]() |
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. |
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. |
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. |
All times are GMT +1. The time now is 11:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com