| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Numbers display as decimal, i.e. enter 123 display 1.23
I have a problem, when I enter a number, eg 123, it displays as 1.23. I have
tried to set up numbers in the format drop down list by eliminating decimal places, but it has no effect. Ideas please |
|
#2
|
|||
|
|||
|
Everyone gets hit with this sooner or later, since they make the
change and nothing seems to happen so they forget they changed this. Tools, Options, Edit, (uncheck) Fixed decimals you had it checked and the decimals set to two The option is useful to Accountants and a pain to almost anyone else. It is not the same as formatting cells to two decimal places. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "IGH219" wrote in message ... I have a problem, when I enter a number, eg 123, it displays as 1.23. I have tried to set up numbers in the format drop down list by eliminating decimal places, but it has no effect. Ideas please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| all the cells in excell put 2 decimal points in all numbers no ma. | Excel Discussion (Misc queries) | |||
| How can I convert binary numbers to decimal when they are larger . | Excel Worksheet Functions | |||
| How do you display 16 digit numbers in excel ? (it keeps convert. | Excel Discussion (Misc queries) | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
| I enter numbers and they are stored as text | Excel Discussion (Misc queries) | |||
Hybrid Mode
