How do I permanantely remove more than 2 decimals

G

Guest

I have Excel 2003.

How can I automatically reduce the number of decimals to only 2 digits not
just in the view part but rather permanetely.

example 2.48469047619048 should become 2.49
 
M

MyVeryOwnSelf

I have Excel 2003.
How can I automatically reduce the number of decimals to only 2 digits
not just in the view part but rather permanetely.

example 2.48469047619048 should become 2.49
Click to expand...

I'm not sure exactly why you're asking, but maybe it'll meet the need to
use:
Tools > Options > Calculation
And check "Precision as displayed."

For details, see Excel's built-in Help under "About calculation in
workbooks" for "Precision of calculation."
 

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

More than two decimal places 1
decimal places 2
decimation 2
not allowing more than 2 decimals 7
Please Help! Automatically moving decimal points 3
Remove Decimals 1
Check for more than 2 decimal places 3
Number format 1

Top