Apply custom Cell Formats

R

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?
 
D

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