ExcelBanter - Replace values with text

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Replace values with text (https://www.excelbanter.com/excel-worksheet-functions/216822-replace-values-text.html)

Mark

Replace values with text

Is it possible to have Excel convert a number into text. For example, I
would like to be able to enter $1, 350 and have "One thousand, three hundred
and fifty dollars" displayed.

Pete_UK

Replace values with text

Take a look at Bob Phillips' site he

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

Hope this helps.

Pete

On Jan 17, 12:51*am, Mark wrote:
Is it possible to have Excel convert a number into text. *For example, I
would like to be able to enter $1, 350 and have "One thousand, three hundred
and fifty dollars" displayed.

All times are GMT +1. The time now is 09:16 AM.