Formatting and Formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

double_rae - 28 Mar 2007 17:40 GMT

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!

Reply to this Message

Gary''s Student - 28 Mar 2007 18:34 GMT

For your second problem:

Tools > Options > Calculation > Automatic

Signature

Gary''s Student
gsnu200712

Reply to this Message

John - 28 Mar 2007 20:36 GMT

just a thought - check the custom format of dd-mmm has not been deleted

Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> I have two problems:
>
[quoted text clipped - 7 lines]
>
> Any ideas? Thanks!

Reply to this Message

doncow - 30 Mar 2007 15:50 GMT

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

> I have two problems:
>
[quoted text clipped - 7 lines]
>
> Any ideas? Thanks!

Reply to this Message