| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Nmber entering
When I enter a number, it enters n/100, i.e. 1 becomes .01. I can't find
anything wrong in formatting. |
|
#2
|
|||
|
|||
|
Tools|options|Edit tab|Uncheck Fixed decimal places
jyh wrote: When I enter a number, it enters n/100, i.e. 1 becomes .01. I can't find anything wrong in formatting. -- Dave Peterson |
|
#3
|
|||
|
|||
|
ToolsOptionsEdit. Uncheck "Fixed Decimal Places".
Gord Dibben Excel MVP On Fri, 18 Feb 2005 17:19:01 -0800, jyh wrote: When I enter a number, it enters n/100, i.e. 1 becomes .01. I can't find anything wrong in formatting. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to draw chat by entering equation | Charts and Charting in Excel | |||
| templates for entering bills | Excel Worksheet Functions | |||
| Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
| why a delay when entering data | Excel Discussion (Misc queries) | |||
| entering matrix formula | Excel Worksheet Functions | |||
Linear Mode
