If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
NUMERIC INPUT TO A CELL
WHENEVER I INPUT A NUMBER INTO A CELL THE NUMBER CONVERTS
TO A 1 100TH OF THE NUMBER E.G INPUT: 9 BECOMES .09 |
#2
|
|||
|
|||
NUMERIC INPUT TO A CELL
Angelo
(Don't type in caps its seen as rude and difficult to read) ToolsOptions...Edit uncheck fixed decimals will cure the problem -- HTH Nick Hodge Southampton, England "ANGELO" wrote in message ... WHENEVER I INPUT A NUMBER INTO A CELL THE NUMBER CONVERTS TO A 1 100TH OF THE NUMBER E.G INPUT: 9 BECOMES .09 |
Thread Tools | |
Display Modes | |
|
|