| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format Cell
Right click on the cell, format cells, under the number tab, select custom,
then in the box, enter 0000000. Copy the format down as necessary. "Fausto" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
![SRS Man[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
