ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i convert figures into words in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/42971-how-do-i-convert-figures-into-words-excel.html)

margeo@ph

how do i convert figures into words in excel?
 
is it possible to automatically convert total amount figures for example into
words in Excel worksheets?
(i.e. 1,205 will appear in anohter cell as "one thousand two hundred five")

Rowan

See

http://support.microsoft.com/default...b;en-us;213360

Regards
Rowan

"margeo@ph" wrote:

is it possible to automatically convert total amount figures for example into
words in Excel worksheets?
(i.e. 1,205 will appear in anohter cell as "one thousand two hundred five")


Bob Phillips

See www.xldynamic.com/source/xld.FAQ0004.html


--

HTH

RP
(remove nothere from the email address if mailing direct)


"margeo@ph" wrote in message
...
is it possible to automatically convert total amount figures for example

into
words in Excel worksheets?
(i.e. 1,205 will appear in anohter cell as "one thousand two hundred

five")




All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com