I am converting numbers to words using formula TOWORDS(X). The formula works fine when I have decimal places e.g. 500.59 it reads five hundred and 59/100. This is exactly what I wanted. but when I have numbers without decimal places, for example in 500 am getting five hundred and xx/100. is there a way I can remove xx/100 where I don't have decimal places but get 59/100 format when i have decimal places?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.