formatting doesn't take affect until clicking in cell

[DKY]

I set up a column with 527 rows as a date formatting but the formatting doesn't work until I click in the actual cell, then click in the formula bar up top and then hit the checkmark to the left of it. Then the formatting works, but I don't want to have to do that with every cell. Is there a way around that? I tried F9 and that doesn't help 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 wrote:
>
> I set up a column with 527 rows as a date formatting but the formatting
> doesn't work until I click in the actual cell, then click in the
> formula bar up top and then hit the checkmark to the left of it. Then
> the formatting works, but I don't want to have to do that with every
> cell. Is there a way around that? I tried F9 and that doesn't help
> either.
>
> --
> DKY
> ------------------------------------------------------------------------
> DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
> View this thread: http://www.excelforum.com/showthread...hreadid=525679

--

Dave Peterson

[DKY]

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