every time i type 9-15in a box, it changes to sep-15!!! how do i make it stop doing that?
2007-03-20 09:48:21 · 8 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
Hi. In excel, when you type in 9-15 or something like 10-15, it changes to the date that should correspond to the number entered. I had some trouble with this too. Are you trying to type 9 minus 15? for that you have to put this into the cell (what's in brakets is in the cell) [=9-15] except for the brackets. Otherwise, you have to right click the cell and go to format cell, then click on number, then click the desired cell format. From here you can align the cell, put different fonts and patterns, and borders also. I hope this was of help to you.
2007-03-20 10:03:05 · answer #1 · answered by ♫ Shinedown ♫ 3 · 0⤊ 0⤋
By default, cells are in General format, which attempts to do some "smart" things, for example, guessing that "9-15" is a date.
"Text" format (via Format->Cells while the cell, column, or region is selected) will remove that guessing.
2007-03-20 09:55:38 · answer #2 · answered by romulusnr 5 · 0⤊ 0⤋
right click the cells you want to change and click format cells, on the number tab pick date and from there you can select the date format that you want displayed.
If it is just the basic number 9-15 then just right click the cells you want to change and click format cells, on the number tab pick text or general and it will show exactly what you type.
2007-03-20 09:54:14 · answer #3 · answered by jackie_1969uk 5 · 0⤊ 0⤋
The cell you are typing in has been set up to out numbers into a date format. Select the cell and go to Format--Cells and pick Text from the category list. Then it will show whatever you type in the cell.
2007-03-20 09:50:34 · answer #4 · answered by hllywood72 5 · 1⤊ 1⤋
right click within the cell and press format cells. then under the heading "number" make sure general is highlighted!! hope it works!!
2007-03-20 09:56:25 · answer #5 · answered by micka5 2 · 0⤊ 0⤋
Put an apostrophe in front of it like this '9-15
or, right click, format cells - text
2007-03-20 09:51:14 · answer #6 · answered by Anonymous · 1⤊ 1⤋
Hi,
Excel feels that you are trying to feed date.
If you want to do a calculation you need to preceed it with equal sign "="
If you want to show this as a text preceed it with " ' " to let Escel understand it as a text.
Regards.
2007-03-24 09:06:56 · answer #7 · answered by suhail62 2 · 0⤊ 0⤋
format cells to text
2007-03-20 09:51:27 · answer #8 · answered by Anonymous · 0⤊ 1⤋