When I type 10 in a cell I keep getting 0.1 instead. Any thoughts

  • Thread starter Enthusiastic new user
  • Start date
E

Enthusiastic new user

Data in cell. When I type the number 10 in a cell 0.1 comes up instead.
After totalling Nos. 10, 20, 25, 30 & 15 total comes as 0.100 instead of 100;
my formual is =sum(E5:E9). I am using EXcel 2003. I go into general and
click on text so I could keep the numbers as stated. I still get it wrong
 
E

Enthusiastic new user

Thank you very much for your expertise. Well done, it has worked. Much
appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top