Formatting and Formulas

[Guest]

I have two problems:

1) When I try to type a date into a cell Excel automatically converts the
data to a formula (=3/27) and I get a mathematical result, even after I have
formatted the cells to be a date.

2) When copying a formula from one cell to another, the new cell displays
the result of the formula in the original cell, although the formula still
appears to be correct.

Any ideas? Thanks!

 

[Guest]

For your second problem:

Tools > Options > Calculation > Automatic

 

[Guest]

just a thought - check the custom format of dd-mmm has not been deleted
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Guest]

Sometimes you can resolve this by putting an apostrophe before the date so
that it does not convert -- '03/30/2007.