Thread: My excel spread sheets are dividing all numbers input by 100.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RickM RickM is offline
external usenet poster
  
Posts: 1
Default My excel spread sheets are dividing all numbers input by 100.
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.

RickM
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.

Reply With QuoteReply With Quote