ExcelBanter - How do I convert $10.10 to "ten and 10/100 dollars" ?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I convert $10.10 to "ten and 10/100 dollars" ? (https://www.excelbanter.com/excel-discussion-misc-queries/140778-how-do-i-convert-%2410-10-ten-10-100-dollars.html)

GLH

How do I convert $10.10 to "ten and 10/100 dollars" ?

Gord Dibben

How do I convert $10.10 to "ten and 10/100 dollars" ?

See Bob Phillips' site for methods.

http://www.xldynamic.com/source/xld.xlFAQ0004.html

Gord Dibben MS Excel MVP

On Fri, 27 Apr 2007 13:12:00 -0700, GLH wrote:

All times are GMT +1. The time now is 06:38 PM.