View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default My excel spread sheets are dividing all numbers input by 100.

"RickM" wrote in message
oups.com...

Prospector wrote:
There are no formula apparent and this occurs on all new worksheets and
even
after reloading the software. The number 3 input appears as 0.03 and so
on.


You have formatted the cells as percentage. Whatever you input will be
divided by 100.

Change the format of the cells to other than percentage.


I think you'll find that formatting as percentage will MULTIPLY by 100, not
divide, Rick.

Gord's suggestion (Fixed decimals) is the usual cause of these symptoms.
--
David Biddulph