Ashish:

Your solution is very good. It adds the leading zero to any size number and
still leaves it a number suitable for calculations,
--
Gary's Student


"Ashish Mathur" wrote:

Hi,

Try this as well. You will not need a helper column

Select the cells and do a Ctrl+1

Now go to custom in the Number tab and click on General on the RHS

Before general add the following (with the quotes) - "0"

Regards,

Ashish Mathur

"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.