ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Format Cell (https://www.excelbanter.com/excel-programming/295298-re-format-cell.html)

Frank Kabel

Format Cell
 
Hi
apply the following custom format ('Format - Cells'):
0000000

--
Regards
Frank Kabel
Frankfurt, Germany


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:07 AM.

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