truncate

G

Guest

How do I truncate my numbers so that $54.2223456 is changed to $54.22? I
know how to round, but I want the actual base number to be truncated, not
simply the number that appears in the cell. All my numbers are currency, so
want two numbers after the decimal. I tried truncating to a certain number
of total characters, but that doesn't help since $54.22 has fewer characters
than $13294.32, but both are correct.
Thanks!
 
G

Guest

You could try..

Tools>Options>Calculation - tick the precision as displayed check box.

Beware. This setting applies to all cells in the workbook. It will convert
them all and the precision will be lost for good. Save a backup first!

Thanks,
Matt
 

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

Conditional Formatting Formula Not Working 1
Convert number to text as displayed 3
Truncate a number using Numeric Format Switch 1
Make Table Query Truncating Memo Field at 255 Characters 2
Format Cols 2
Truncate scientific notation 1
find and replace numeric strings in larger text strings 8
Truncating numbers 1

Top