MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I don't want Excel to round

Posted by Nick G on September 17, 2001 6:45 AM

Can I get Excel not to round? In other words, if the answer to be returned should be $6.09999994, I want the answer to say $6.09999994 not $6.10. Is there any way to accomplish this?

Posted by Mark W. on September 17, 2001 6:49 AM

Use $0.00000000 as your number format