MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Number formatting


Posted by Tsering on November 19, 2001 2:59 AM

Please help! All round numbers eg. 10, 100, 1000 are automatically being divided by 100 and so come up as 0.10, 1 and 10. What can i do to correct this?


Posted by Robin on November 19, 2001 3:33 AM

Tools, Options, Edit - remove the check mark from "fixed decimal"!