Every time I type in Excel 20.5 it show as 20.May but i don't want 20.May do you know how do I change it?

Answer 1

in the cell or cells that you have this problem .....
right click
choose format cells
under the "number" tag....choose... number
OK

this will do it!

Answer 2

A better explanation....

This is due to excel having the format of cells general by default and thinking you are entering a date.

To change the format
1. Select all cells you want to apply this on.
2. Press Ctrl+1 OR Click Format Menu > Cells

3. In Numbers Tab Click the category Number
4. Select the decimal places to see
(if you want 20.5 as a date then click category date and select your format)

5. Click OK

HTH

Answer 3

if you are trying to enter a date as 20.5 then click on the cell that you want to change [format] then click on the format drop down menu, click on cells and at the bottom is custom or special, click on that and from that menu select dd/mm/yy then click within dd/mm/yy customise it with the delete and backspace buttons, thus dd m.

Answer 4

enter the number you want, click on Number tab, then Cells, click number again under the category and change the decimal places to 2. hope that helps

Answer 5

right click on the cell,click format cell...go to number tab and thencorrect decimal places...u need 2.5 select 1 in decimal places..

Answer 6

Go to my computer than control panel than Regional and Languages option, there go to customize. there your problem will be solved.