Thread: add leading "0"
View Single Post
  #4   Report Post  
Ashish Mathur
 
Posts: n/a
Default

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.