Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help!
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 |