Date and Sum functions (HELP)

[aaronr]

I've put together a spread sheet, it works good the problem is when I put in something like +6 / +16 it automatically does the formula for it and when I put something like 10/10 it will put the date in as 10-Oct. How do I make the spread sheet take the data as entered and not do this formatting for me.

[BruceP]

Have you made sure that the cell is formatted for numbers, and not dates?

[Bob Phillips]

Maybe

=10/10


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"aaronr" <[email protected]> wrote in
message news:[email protected]...
>
> I've put together a spread sheet, it works good the problem is when I
> put in something like +6 / +16 it automatically does the formula for it
> and when I put something like 10/10 it will put the date in as 10-Oct.
> How do I make the spread sheet take the data as entered and not do this
> formatting for me.
>
>
> --
> aaronr
> ------------------------------------------------------------------------
> aaronr's Profile:
http://www.excelforum.com/member.php...o&userid=33652
> View this thread: http://www.excelforum.com/showthread...hreadid=534272
>