Thread: add leading "0"
View Single Post
  #2   Report Post  
Gary's Student
 
Posts: n/a
Default

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.