| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Date Math Problem | Excel Worksheet Functions | |||
Linear Mode
