Microsoft Excel Question:
Download Questions PDF

When I type a number, example 44, it becomes 0.44 even if I format the cell without decimals?

Answer:

Goto Tools>Options/Edit and uncheck the Fixed decimals checkbox.

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
When I clear a large range, it takes forever. How can I make it faster?Is there a way to allow the use of AutoFilter on a protected worksheet?