Let's assume that the cells are in a column (say A):
1. insert a helper column near by
2. format the cells in the helper column as text
3. in the helper column insert
="0"&A1
4. copy this down
5. copy the helper column and paste it as value back into Column A.
__________________________________________________ ___
You can avoid this if all your numbers are of fixed length, then use custom
formatting:
Format Cells Number Custom
and enter as many zeros as you like
--
Gary's Student
"blt" wrote:
How can I mass add a 0 to a field.
example: 544 = 0544 But I have about 2000 lines and I would like to mass
add them.
|