Software

Ask something
Discussion Locked

Convert Digit into "words"

0 helpful
9 replies

by b_heart1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to convert say 197 written at any cell to
words format as "One hundred and ninety seven" in
current sheet.

P.S. I have used bahttext() function it results
only in Thai. I need result in English.

9 replies

by sheryl v

I don't know how to make it work in XL, but I have code that works great in MSAccess which I'd be glad to e-mail you, too long for the answer box (to many characters) You could then copy and paste it into a new module in Access and link to the XL file that has the numbers to convert in it, & create a query on that table using this function. You could then send the query back to Excel for the finished product. Probably not the answer you want, but it is a work around...

let me know if you want the code. Sheryl.verwey@us.nestle.com

This discussion is closed to new replies.