Thread
:
convert $10.20 to text ...Ten Dollars &20/100
View Single Post
#
5
Posted to microsoft.public.excel.misc
shapiro
external usenet poster
Posts: 34
convert $10.20 to text ...Ten Dollars &20/100
Hi Bob,
I used =SpellNumber(A1,TRUE,"Pounds","",",",TRUE) and the VBA code for the
URL. Because it was the only code that had the fraction i.e. 45/100
Reply With Quote
shapiro
View Public Profile
Find all posts by shapiro
convert $10.20 to text ...Ten Dollars &20/100