ExcelBanter - Format Cell

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Format Cell (https://www.excelbanter.com/excel-programming/295329-re-format-cell.html)

JWolf

Format Cell

Custom Format: General 0000000 "000"0
5080 0005080 0005080
508 0000508 000508
50 0000050 00050
5 0000005 0005

Fausto wrote:

Hi guys.
How can I have a cell to show 3 zeros before a number automaticaly.
In other words If I enter 5080 in any cell in Column A. It will display 0005080

Thank you

All times are GMT +1. The time now is 10:09 AM.