Hi Guys,

In the last couple of months while I've been
getting up to speed a bit in Excel many of you
have helped me tremendously. Thanks again.

But 2 things drive me batty... and take hours of mucking
about!

The first is entering a date in dd mmm yyyy format and Excel
changing it to some other format.
The other is linking the sheet into Access and finding half your
work has turned to #NUM!.... so you re-enter it all, go back
to Excel and it's all a different font and colour. So you fix
it and sometimes it's a #NUM again, sometimes not.

Can this be rectified? Can you set a cell attribute and make it stay
that way ?
Thanks - Kirk