| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Input ~ Display
Help! When inputting a number (i.e. 2) into a cell it displays as 0.02 ~ if
222 is entered it displays 2.22 this is whether the cell is formatted as General, Number or Currency ~ Currency displays £0.02. Have checked Regional & Language Options the Excel Options and all seems OK. Regards Ronnie Email: |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Input ~ Display
try.
Tools|options|edit uncheck fixed decimal places Mike "Ronnie" wrote: Help! When inputting a number (i.e. 2) into a cell it displays as 0.02 ~ if 222 is entered it displays 2.22 this is whether the cell is formatted as General, Number or Currency ~ Currency displays £0.02. Have checked Regional & Language Options the Excel Options and all seems OK. Regards Ronnie Email: |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Input ~ Display
Hi Mike,
It worked Sincere Thanks Ronnie "Mike H" wrote: try. Tools|options|edit uncheck fixed decimal places Mike "Ronnie" wrote: Help! When inputting a number (i.e. 2) into a cell it displays as 0.02 ~ if 222 is entered it displays 2.22 this is whether the cell is formatted as General, Number or Currency ~ Currency displays £0.02. Have checked Regional & Language Options the Excel Options and all seems OK. Regards Ronnie Email: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Discussion (Misc queries) | |||
| Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Worksheet Functions | |||
| How do I input 2525 to display 25.25 | Excel Discussion (Misc queries) | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| Want to input one character to cause related string to display in. | Excel Worksheet Functions | |||
Linear Mode
