Because you're using the OFFSET() to get the date into that merged cell at
K15:... it doesn't pick up the formatting from the source cell in column B.
Fix should be easy, just click in the merged cell there at K and format it as
a date separately.

" wrote:


wrote:
JLatham wrote:
Is all of that (the graphic, command buttons, and text boxes) too much to
allow you simply to make row 1 taller and put them up into it so that they
remain above the freeze line and still have usable space on the screen to
work with?

You were right. I redesigned the whole thing and it even looks better.
However, now I have a new problem. The date won't format as a date. I
did it the same way I did on the old one.

Please look at www.digitalbirdcrap.com/pass.html

I Print Screened the page and pasted it there to show the problem.

Thanks
Johnne