|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Any method of formatting a cell that will return a number value with pronounceable text.
Any method of formatting a cell that will return a number value with pronounceable text. cell contains "53,768" cell would return "fifty-three thousand, seven-hundred and sixty-eight". |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Thanks. I will give it a go.
|
#4
|
|||
|
|||
getting an error from this line
Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2)) |
#5
|
|||
|
|||
Not certain what would cause the error. I've run the code here and it works fine.
Perhaps post your workbook ? |
#6
|
|||
|
|||
I guess I need to learn MSVB.
|
#7
|
|||
|
|||
Post your workbook without confidential information ... I'll look at it for you.
|
#8
|
|||
|
|||
Fairly new here. Not sure where to upload a file after starting a post.
|
#9
|
|||
|
|||
Down below where you write your messages ... click on GO ADVANCED. Look around after that to see about attaching a file.
|
#10
|
|||
|
|||
Found it.
Found it. It is a macro enabled workbook.
|
#11
|
|||
|
|||
The original code from the website had two lines (the one you mentioned and another one further down) that were using the "underscore" symbol. That allows a line of code to be broken down into shorter lengths so the entire line can be visible to the coder when writing the code. Otherwise, some lines of code would extend far off to the right side of the coding window and make it difficult to view.
In any case, the corrected version is attached. You can experiment with the code to get rid of the "Cents" and "Dollars" so all you are left with is the number itself. Might want to experiment with a copy of the file so you don't mess up the original one. Cheers and stay healthy ! |
#12
|
|||
|
|||
Sweet. Thanks!
|
#13
|
|||
|
|||
You are welcome. Stay healthy !
|
Tags |
format numbers, pronounceable, text |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
for visible cells (filtered), how find value lowest than 4.00 and return the cell number | murfy69 | Excel | 6 | 08-03-2017 12:03 AM |
Return Max Text or Number Value based on Criteria | kwilson307 | Excel | 1 | 04-20-2017 05:07 AM |
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting | hanvyj | Excel Programming | 0 | 08-28-2015 01:15 AM |
Find text within cell and return column and row title next to the name on a new sheet. | tanyabowring@live.co.uk | Excel Programming | 2 | 03-26-2015 01:48 AM |
Search for multiple texts in cell, return specific text | mariur89 | Excel | 4 | 12-14-2014 01:33 AM |