software

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: www.excelforum.com/member.php...oamp;userid=33652
View this thread: www.excelforum.com/showthread...hreadid=534272
Have you made sure that the cell is formatted for numbers, and not
dates?--
BruceP
------------------------------------------------------------------------
BruceP's Profile: www.excelforum.com/member.php...oamp;userid=33653
View this thread: www.excelforum.com/showthread...hreadid=534272Maybe

=10/10--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;aaronrquot; gt; wrote in
message ...
gt;
gt; I've put together a spread sheet, it works good the problem is when I
gt; put in something like 6 / 16 it automatically does the formula for it
gt; and when I put something like 10/10 it will put the date in as 10-Oct.
gt; How do I make the spread sheet take the data as entered and not do this
gt; formatting for me.
gt;
gt;
gt; --
gt; aaronr
gt; ------------------------------------------------------------------------
gt; aaronr's Profile:
www.excelforum.com/member.php...oamp;userid=33652
gt; View this thread: www.excelforum.com/showthread...hreadid=534272
gt;