Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO ZERO FILL A CELL THAT CONTAINS OTHER DATA EX. 000123?
I need to fill cells 15 charecters in length with zeroes, the cells have
numbers in them already, ex. 45678 needs to read 000000000045678. The numers in the cells are not the same length, some are 4 charecters up to 7 charechters. Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Last cell of data in a column | Excel Discussion (Misc queries) | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
data in cell not corresponding with entry | New Users to Excel | |||
Input Cell in One variable data table | Excel Worksheet Functions |