Home »
Excel Tips
» Put zeros before a number while keeping the possibility of calculating
Put zeros before a number while keeping the possibility of calculating
Very useful to align the numbers in a cell
|
the walk-through: use the custom formatting |
Procedure
- selecting the cell or cells
- Format dropdown menu
- cell line
- In the window that opens many tab should be selected by default
- place the dropdown
- and at the end select the option "Custom
- and in the box type as zero indicate that we want numbers
- and confirm with OK
- verify that you have
|
Post a Comment