View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Date and Sum functions (HELP)

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