im wondering if anyone knows how to turn off or bypass the automatic date changer. for example: when i put "4-7" in one of the cells, it changes it to "7-Apr"...and thats definately not what i wanted. so instead i used "4 - 7" and it worked. BUT on the next cell i put in "8 - 11" and it still changed it to "8-Aug" can anyone help me? this is driving me crazy!
2007-01-18 13:47:18 · 8 answers · asked by laura 4 in Computers & Internet ➔ Software
Simply put a single ', that is, an apostrophe, in front of the date. It will kill any internal coding and allow you to type whatever you wish. :)
2007-01-18 13:52:01 · answer #1 · answered by Acadia 3 · 1⤊ 0⤋
It just a formatting that is applied to the cell. Select the entire column that you are entering the dates in. Right click and then click format cells, or click on format on the tool bar. When the dialog box comes up click on the "number" tab. Click on the date category on the left hand side and then on the right click the format you would like.
2007-01-18 21:54:55 · answer #2 · answered by I_dunno 3 · 0⤊ 0⤋
Options:
A) Hit the ' before you type anything else. This will tell excel that you are entering text not a date.
B) Highlight the cells (or column) that you are going to enter the numbers into and then click on the 'Format' menu: 'Format Cells'. Choose 'Text' from the 'Category' list on the left hand side. This tells excel you are entering text in these cells not dates.
2007-01-18 21:54:36 · answer #3 · answered by Anonymous · 1⤊ 0⤋
All of the answers are oko but telling you nothing
ok in the cell you want to format just right click-format- then a format box will open click on the Number tab scroll to date and on the right side choose the type of date you want to show.
2007-01-18 22:26:06 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Go to format cells and change the format
Example: 1/07/07, or 8-01-07, or 8-SEP-07
2007-01-18 21:56:03 · answer #5 · answered by jerseygirl3510 2 · 0⤊ 0⤋
Format>Cells
Then select the date format you want or change the data from date field to something else.
2007-01-18 21:51:47 · answer #6 · answered by snvffy 7 · 0⤊ 0⤋
Click format, cells, number tab, click date and select the type you want.
If you're not able to work it out with this suggestion, all else I can suggest is trying this:
Try this formula:
=LEFT(A1,4)&"/"&(MID(A1,5,2)&"/"&RIGHT(A1,2))
Let me know if that helps...Good Luck!
2007-01-18 22:01:04 · answer #7 · answered by Rmprrmbouncer 5 · 0⤊ 0⤋
Your date formating is wrong. You need to modify it.
2007-01-18 21:50:18 · answer #8 · answered by croff 2 · 0⤊ 2⤋