extract decimal portion of a number

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

Guest

I need to extract the decimal portion of a number....any ideas how?

for example, I have a SINGLE variable that will read, for example, 10.83.

Hope do extract the decimal (.83) portion and place into a seperate variable
for processing.

Thx
 
Ed said:
I need to extract the decimal portion of a number....any ideas how?

for example, I have a SINGLE variable that will read, for example,
10.83.

Hope do extract the decimal (.83) portion and place into a seperate
variable for processing.

Thx
Click to expand...

Example:

v = 10.83
Debug.Print v - Fix(v)
 

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

Extract portion of a cell 4
Create a Search Based on Decimal Precision 4
Extracting Date from Date/Time Field 2
Numeric increment 4
Excel How To Convert Decimal To Inches 2
Access stripping decimal places in query 1
extract decimal and convert to integer 9
Imported numbers missing decimals 5

Back
Top