when i want to type numbers or letters in the box on excel, the text i type turns into totally different numbers. Why does this happen and how can i stop it from doing that?
2006-09-22 14:04:51 · 9 answers · asked by Maria 1 in Computers & Internet ➔ Hardware ➔ Desktops
It is probably because of the formatting of the worksheet.
You can adjust the format type by selecting the area to format, then
> Select the area of the wroksheet to format
> Right-click and select 'Format Cells'
> Select 'Number' from the 'Category' section
> Choose if you want to include a decimal
> Set to '2' for money currency format
> Set to '0' for no decimal place
> Click 'OK'
That's it!
**************
Note:
Excel is an awesome program, that was written by extremely smart people. It has sooooo many cool functions and features, that it would almost take a lifetime to learn everything that it has to offer.
This is, by far, one of my favorite programs EVER!!!
2006-09-22 15:24:29 · answer #1 · answered by Sandy 4 · 0⤊ 0⤋
Sometimes Excel will automatically change the number format of a cell depending on how you type numbers into it. For example, if you type 5/5/5, it will probably turn into a date. To keep this from happening, try putting an apostrophe before the numbers. That will make it display properly (although note that in that case it will no longer work for functions).
2006-09-22 21:07:06 · answer #2 · answered by Anonymous · 0⤊ 0⤋
You need to reformat the cell, which is the field that you enter in the numbers.
Just select the whole sheet and then click on format and then cells, and choose general or numbers or whatever you want to show.
Good luck.
2006-09-22 21:12:03 · answer #3 · answered by caentpri 1 · 1⤊ 0⤋
Highlight the cells in question. In the toolbar at the top, click on Format, Cells, and highlight Text from the menu, click OK. The cells will then show exactly what you type into them.
2006-09-22 21:09:54 · answer #4 · answered by Stimpy 7 · 0⤊ 0⤋
Right click and select "format cell". Under the "Number" tab (the first tab) there is one of those you need to select, and I'm pretty sure it's "text." If not, just try them and pick the one that keeps the actual number you entered.
2006-09-22 21:07:04 · answer #5 · answered by Anonymous · 1⤊ 0⤋
go to format>Cells and then change the type you want it to be(date, time, general, etc...)
Sometimes if you put a date it changes it to numbers because of the date system used in Excel.
2006-09-22 21:07:44 · answer #6 · answered by Anonymous · 0⤊ 0⤋
maybe you have the Num Lock on. or if u have the mauel u should read the section for Microsoft Excel.
2006-09-22 21:08:28 · answer #7 · answered by Anonymous · 0⤊ 0⤋
Have you checked your font setting? Some fonts are actually character symbols.
You can also research about excel on http://office.microsoft.com/en-us/default.aspx
2006-09-22 21:09:04 · answer #8 · answered by redheadwithaspark 1 · 0⤊ 0⤋
I THINK YOU HAVE SELECTED YOUR FONT OF OTHER LANGUAGE WHICH YOU DONT UNDERSTAND SO CHANGE YOUR FONTS TO ARIAL OR TIMES NEW ROMAN TO GET THE BEST RESULT. TRY IT
BEST OF LUCK
2006-09-23 03:52:03 · answer #9 · answered by Anonymous · 0⤊ 0⤋