LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"