| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stop Excel from converting integers into decimals (eg.; 12 to .12)
Recently Excel has started converting very number entered into that number
entered divided by 100. For example, every numerical entry n, becomes n/100. This can be over-ridden if one enters "n.", thereby forcing the decimal. This happens regard less of the format selected for number, currency, percent, etc. It is some kind of global formatting that is defined in new as well as old workbooks. It began a few weeks ago on both my home and my work machine. "Help" is no help. Surprise! How does one shut this off? Help!! Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Excel from converting integers into decimals? | Setting up and Configuration of Excel | |||
| stop rounding up in a colum that contains decimals in excel | Excel Worksheet Functions | |||
| how to diferentiate integers with decimals in the IF formulas | Excel Worksheet Functions | |||
| Converting decimals into hh:mm | Excel Worksheet Functions | |||
| converting to Integers | Excel Worksheet Functions | |||
Threaded Mode
