# Getting rid of unwanted decimals

1. ## Getting rid of unwanted decimals

Hello, this is the formula; =(C7*100)/C4&"Kar" and the cell shows; 11.3374168521274Kar, I want to preview it like this; 11.33 Kar or 11.34 Kar , with a gap. How can I do it? Thanks..

2. ## Re: Getting rid of unwanted decimals

Try:
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Getting rid of unwanted decimals

Thank you very much

4. ## Re: Getting rid of unwanted decimals

You're welcome. Thanks for the rep.

5. ## Re: Getting rid of unwanted decimals

You could also just use this formula in your cell...

=(C7*100)/C4

and then Custom Format the cell using this Type pattern...

0.00" Kar"

That way, should you need to use this number in future calculations, it will usable directly... and at its actually calculated value as opposed to its rounded value.

6. ## Re: Getting rid of unwanted decimals

Originally Posted by Rick Rothstein
You could also just use this formula in your cell...

=(C7*100)/C4

and then Custom Format the cell using this Type pattern...

0.00" Kar"

That way, should you need to use this number in future calculations, it will usable directly... and at its actually calculated value as opposed to its rounded value.
Thanks a lot for that. Can I ask one more thing? How can I remove that #DIV warning and 0.000's? I'm trying to make every cell blank if they are not being used. Should I make a new topic?

7. ## Re: Getting rid of unwanted decimals

For my suggestion (you can use a similar approach for TMS's code), change the formula you put in the cell to this...

=IFERROR(C7*100)/C4,"")

8. ## Re: Getting rid of unwanted decimals

Works perfectly, thanks..

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1