Apply custom Cell Formats

[Randy]

I have created a custom format to zero fill a field that
already contains data, but it will only work if I edit the
field and press enter.

How can I apply the custom format without touching every
cell in the column of data?

 

[Dave Peterson]

It sounds like your numbers are actually text.

Try this:
select an empty cell
copy it
select your range (that'll get the custom format)
edit|paste special|check the Add button under Operation.

Now apply the custom format.

 

[Randy]

That worked Great

Thanks..Dave! Saved me hours....