How to convert a decimal number to a non-decimal number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking to convert a decimal number(3.75) to a non-decimal number(375)
using a formulas. as I have hundreds of these to do.
 
Try
In a blank cell enter 100. Copy this cell and then highlight the cells you
want to convert. Right click and click paste special select values and
multiply.

HTH
 
Are all your numbers 2 decimal places or are some greater. Assuming you
have a mix, put 100 in a cell, copy the cell, select all your values at once
and do Edit / Paste special / Multiply. Now format all the cells so that
you only see integers and then do Tools / Options / Calculation tab / Check
precision as displayed. Hit OK and then go back in and uncheck it. Note
though that you will lose any decimal data anywhere in that tab.
 

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

Convert Decimal fractions to binary and vice versa 1
convert time to decimal 2
Decimal to Time Format. 5
Access stripping decimal places in query 1
Excel How To Convert Decimal To Inches 2
Trim varying decimals from column of numbers 9
Access Convert a decimal time to hours and minutes 2
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m 1

Back
Top