Dear Roger,

You are a star - thanks so much.

All the very best for the festive period and 2007.

Sincere regards

Ron

"Roger Govier" wrote:

Hi Ronald

On the offending sheet, ToolsOptionsTransitionremove selection from
Transition formula entry

--
Regards

Roger Govier


"RonaldAC" wrote in message
...
Dear Excel Experts,

I have an odd problem I cannot find an answer to using the search
facility -
it is on the odd occassion I have multiple sheets and use date input
for most
of the financial modelling I do. My problem is that if I have say 6
sheets in
a work file and I find I can enter 14/12/06 on 5 of them (any cell)
and the
sheet will come up with the expect result (39,065) but on one sheet
all I get
is 0.194444 recuring (which the resultant of the numbers dividing).
How can
this happen or what needs to be done to fix it?

Thanking you in anticipation