ExcelBanter - how do I show 07 instead of 7

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - how do I show 07 instead of 7 (https://www.excelbanter.com/new-users-excel/181014-how-do-i-show-07-instead-7-a.html)

teapot

how do I show 07 instead of 7

Per Jessen

how do I show 07 instead of 7

Hi

Select the cell(s) Format Cells Number Costum In the type field
enter ##00 Ok

Regards,

Per

"teapot" skrev i meddelelsen
...

All times are GMT +1. The time now is 01:13 AM.