| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Troubleshooting
When I type a number ie. 4, when I move to another cell it becomes 0.40. I
numerous methods. It must be a setting as it repeats itself on new xls's |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Troubleshooting
Hi,
Tools|Options|Edit tab Uncheck 'fixed decimal places' Mike "David Rogers" wrote: When I type a number ie. 4, when I move to another cell it becomes 0.40. I numerous methods. It must be a setting as it repeats itself on new xls's |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Troubleshooting
Tools/ Options/ Edit
Uncheck the entry for Fixed decimal places. -- David Biddulph "David Rogers" <David wrote in message ... When I type a number ie. 4, when I move to another cell it becomes 0.40. I numerous methods. It must be a setting as it repeats itself on new xls's |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Troubleshooting Spreadsheets | Excel Discussion (Misc queries) | |||
| Troubleshooting my IF formula | Excel Discussion (Misc queries) | |||
| SUMPRODUCT troubleshooting | Excel Worksheet Functions | |||
| troubleshooting | Setting up and Configuration of Excel | |||
| Template troubleshooting... | Setting up and Configuration of Excel | |||
Linear Mode
