View Single Post
  #1   Report Post  
AndyB
 
Posts: n/a
Default 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