Crazy Formatting Issue!

[Beefeater]

It won't format until I double click it to get to edit, THEN click off.

Just take a look, it boggles my mind!!!


http://ga.uno.edu/EVIL.xls

Hi
One way is to select the whole range. Press F2 and then Ctrl+Enter.
Another is to copy a blank unused cell, select your range and then
Edit/Paste Special/Add. Then format the range as date as required.

Andy.

"Beefeater" <[email protected]> wrote
in message news:[email protected]...
>
> It won't format until I double click it to get to edit, THEN click off.
>
> Just take a look, it boggles my mind!!!
>
>
> http://ga.uno.edu/EVIL.xls
>
>
> --
> Beefeater
> ------------------------------------------------------------------------
> Beefeater's Profile:
> http://www.excelforum.com/member.php...o&userid=35423
> View this thread: http://www.excelforum.com/showthread...hreadid=551910
>