split a number

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

Guest

good day all...

how do I "split" a decimal number with a leading number and two decimals?
I.E. 4.75?

Thanks,

Brook
 
Whole Number: Int([YourNumField])
Fraction: [YourNumField] - Int([YourNumField])
 
Thank you very much...

That worked perfectly!

Brook

KARL DEWEY said:
Whole Number: Int([YourNumField])
Fraction: [YourNumField] - Int([YourNumField])

Brook said:
good day all...

how do I "split" a decimal number with a leading number and two decimals?
I.E. 4.75?

Thanks,

Brook
Click to expand...
Click to expand...
 
You must log in or register to reply here.

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

Mobile phone texts split into incoming and outgoing messages 0
Convert Number? 5
is there a calendar template that fits a cd case? 1
Hanging decimal places with custom number format 2
Decimal Places 1
decimal point in general number 1
Number Format 2
Splitting decimals 1

Back
Top