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

No responces but here's something I found
later.
Just in case it helps someone else:

http://www.dailydoseofexcel.com/arch...ed-data-types/

Cheers - Kirk


On Thu, 28 Sep 2006 17:32:32 +1200, kirkm
wrote:

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