Decimal Display

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
Arlene_Mourier_(Guest)
Posts: 1
Joined: Tue Oct 10, 2017 12:44 pm

Decimal Display

Post by Arlene_Mourier_(Guest) » Mon Jul 30, 2007 12:27 pm

I am trying to create a field that will display the decimal portion of a total field. I am converting the numeric integers to words using the SPELLNUM function, but this does not spell out the decimals. My preference would be to display the decimals as numeric. Any ideas?

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Decimal Display

Post by kfleming » Wed Aug 01, 2007 10:23 am

total-int(total)____should give you just the decimal part of the total as a number.____Kathleen__R&R Support__

Post Reply