Number Formating

D

darcy.mckeown

For some reason, everytime i am typing a number in excel, the last two
digits are made into decimal. For example, if I type "1,023" into a
cell, once i hit enter it becomes "10.23" in the cell. How do I fix
this? Thanks
 

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

Similar Threads

Scanning a Number into Excel 2
Per hour calculation using whole number and hh:mm:ss 1
Number entries are automatically divided by 100 - Excel 2003 1
Formatting long decimal numbers as TEXT cell, not refreshing? 2
Entering 18 digit number in Excel 9
Count Conditional formating data 3
How do I prevent the cell from changing the number I enter? 2
Excel Cell 1

Top