formatting doesn't take affect until clicking in cell

[DKY]

I set up a column with 527 rows as a date formatting but the formattin
doesn't work until I click in the actual cell, then click in th
formula bar up top and then hit the checkmark to the left of it. The
the formatting works, but I don't want to have to do that with ever
cell. Is there a way around that? I tried F9 and that doesn't hel
either

 

[Dave Peterson]

It sounds like you have text that looks like numbers in those cells.

You can try this:

Select an empty cell
edit|copy
select that column of text "numbers"
edit|paste special|check Add

And apply the format one more time.

 

[DKY]

interestingly enough, that worked. I never would have thought of that