CONVERT NUMBER IN TEXT

Question

Level 1

4 points

CONVERT NUMBER IN TEXT

HOW CAN I CHANGE AN AMOUNT IN NUMBERS TO LETTERS IN NUMBERS

MacBook Pro

Posted on Sep 14, 2022 10:30 AM

Reply

Answer 1

Best reply

Badunit

Level 7

26,338 points

Sep 14, 2022 2:15 PM in response to JLG-1

Do you mean like converting 123 to "one hundred twenty three"?

Reply

Answer 2

Badunit

Level 7

26,338 points

Sep 14, 2022 2:39 PM in response to JLG-1

It is not a simple little formula or function. I have a spreadsheet that requires a long table of words to look up and a very long formula to do the conversion. I'll post a link to it but it may get removed. I'm a little unclear on the rules for posting links these days. What you want is on Sheet 1.

[Link Edited by Moderator]

Reply