Date entries in Excel Sheets
 

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

Date entries in Excel Sheets
 

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

Date entries in Excel Sheets
 

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

Date entries in Excel Sheets
 

hi Ron

You're very welcome.
Thanks for the feedback and very best wishes to you and yours for
Christmas and the new Year.

--
Regards

Roger Govier


"RonaldAC" wrote in message
...
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