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

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


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=534272

Maybe

=10/10


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"aaronr" wrote in
message ...

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