ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I insert .00 after a number (https://www.excelbanter.com/new-users-excel/67020-how-do-i-insert-00-after-number.html)

Susan from Wales

How do I insert .00 after a number
 
I am typing columns of figures in Excel, I would like all figures to go to 2
dec places. Is this possible and how do you do it?

Bill Ridgeway

How do I insert .00 after a number
 
Format the row, cell or column (as appropriate) -

<Format<Cells<Number

and change decimals places to 2

Regards.

Bill Ridgeway
Computer Solutions

"Susan from Wales" <Susan from wrote in
message ...
I am typing columns of figures in Excel, I would like all figures to go to
2
dec places. Is this possible and how do you do it?





All times are GMT +1. The time now is 08:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com