Find Decimal and give me left

B

Bahboosh

I need a formula that can find the decimal in a cell and then give me
the numbers to its left. I dont want to round, I just need the formula
that can give me the digits left to the decimal.

Ex: 1.45 ==> 1
12.97 ==> 12

Thanks
 

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

Solver loose decimal when re-opened 2
Formatting long decimal numbers as TEXT cell, not refreshing? 2
Replace massively formulas with new formulas 4
Access stripping decimal places in query 1
number format - minus sign away from number 2
no decimal point if zero 19
Excel Percents formatted for 1 decimal place 3
RAND and only 1 decimal 12

Top