| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
When I type in 100 a 1 appears, 10000 and 100 appear
Hi
When I type in 100 I get a 1 appearing in a cell. If I type in 1 then .01 appears in a cell. The cells are formated as number with 2decimal places. If I set format to percent, I type in a 1 and 1.00% is shown. The numbers I'm typing in appear to be divided by 100. Any suggestions -- Regards Andy |
|
#2
|
|||
|
|||
|
Use Tools|options form menu
Open Edit tab and clear the Fixed Decimals box best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "AndyB" wrote in message ... Hi When I type in 100 I get a 1 appearing in a cell. If I type in 1 then .01 appears in a cell. The cells are formated as number with 2decimal places. If I set format to percent, I type in a 1 and 1.00% is shown. The numbers I'm typing in appear to be divided by 100. Any suggestions -- Regards Andy |
|
#3
|
|||
|
|||
|
Hi
Thank you for the answer. It worked perfectly. How the decimal tab got set I've no idea! Anyway - Thank you again -- Regards Andy "Bernard Liengme" wrote: Use Tools|options form menu Open Edit tab and clear the Fixed Decimals box best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "AndyB" wrote in message ... Hi When I type in 100 I get a 1 appearing in a cell. If I type in 1 then .01 appears in a cell. The cells are formated as number with 2decimal places. If I set format to percent, I type in a 1 and 1.00% is shown. The numbers I'm typing in appear to be divided by 100. Any suggestions -- Regards Andy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
