Apply custom Cell Formats

  • Thread starter Thread starter Randy
  • Start date Start date
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?
 
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.
 
Back
Top