ExcelBanter - can I replace Â£200 by text eg.two hundred pounds

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

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

- - can I replace Â£200 by text eg.two hundred pounds (https://www.excelbanter.com/excel-discussion-misc-queries/110941-can-i-replace-%C2%A3200-text-eg-two-hundred-pounds.html)

Liz

can I replace Â£200 by text eg.two hundred pounds

Is it possible to replace currency value by text in Excel spreadsheet?

Niek Otten

can I replace £200 by text eg.two hundred pounds

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Liz" wrote in message ...
| Is it possible to replace currency value by text in Excel spreadsheet?

All times are GMT +1. The time now is 10:52 AM.