Getting rid of the date

[alex24057]

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

 

[alex24057]

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

 

[alex24057]

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

 

[Peo Sjoblom]

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]

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

 

[alex24057]

This appears less of a hassle than putting an apostrophe in front eac
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" <[email protected]
wrote in
message news:[email protected]...

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

http://www.excelforum.com/showthread.php?threadid=517124