Getting rid of the date
 

I'm trying to get rid of the date, it is already on another part of the
spreadsheet. The problem is that everytime I enter a set of numbers
such as 2/2 or 2-2 the date will appear. How do I get rid of this?


--
alex24057
------------------------------------------------------------------------
alex24057's Profile: http://www.excelforum.com/member.php...o&userid=31986
View this thread: http://www.excelforum.com/showthread...hreadid=517124

Getting rid of the date
 

926 Smith Sam 8/29/1996 M2 9 X 5 3 6 5/5(it won't allow me to do
this) M2


--
alex24057
------------------------------------------------------------------------
alex24057's Profile: http://www.excelforum.com/member.php...o&userid=31986
View this thread: http://www.excelforum.com/showthread...hreadid=517124

Getting rid of the date
 

926 Smith Sam 8/29/1996 M2 9 X 5 3 6 *5-May* M2


--
alex24057
------------------------------------------------------------------------
alex24057's Profile: http://www.excelforum.com/member.php...o&userid=31986
View this thread: http://www.excelforum.com/showthread...hreadid=517124

Getting rid of the date
 

Precede the entry with an apostrophe or format as text before you enter
anything

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"alex24057" wrote in
message ...

926 Smith Sam 8/29/1996 M2 9 X 5 3 6 *5-May* M2


--
alex24057
------------------------------------------------------------------------
alex24057's Profile:
http://www.excelforum.com/member.php...o&userid=31986
View this thread: http://www.excelforum.com/showthread...hreadid=517124

Getting rid of the date
 

Never mind, I found the answer by search through the forums. Just put an
apostrophe in front of the number. Thanks anyways.


--
alex24057
------------------------------------------------------------------------
alex24057's Profile: http://www.excelforum.com/member.php...o&userid=31986
View this thread: http://www.excelforum.com/showthread...hreadid=517124

Getting rid of the date
 

This appears less of a hassle than putting an apostrophe in front each
number. Thanks for the help!

or format as text before you enter
anything

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"alex24057"
wrote in
message ...

926 Smith Sam 8/29/1996 M2 9 X 5 3 6 *5-May* M2


--
alex24057

------------------------------------------------------------------------
alex24057's Profile:
http://www.excelforum.com/member.php...o&userid=31986
View this thread:
http://www.excelforum.com/showthread...hreadid=517124



--
alex24057
------------------------------------------------------------------------
alex24057's Profile: http://www.excelforum.com/member.php...o&userid=31986
View this thread: http://www.excelforum.com/showthread...hreadid=517124