Formatting and Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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)
 
Sometimes you can resolve this by putting an apostrophe before the date so
that it does not convert -- '03/30/2007.
 
Back
Top