![]() |
|
|
Thread Tools | Display Modes |
#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 ! |
Tags |
format numbers, pronounceable, text |
|
![]() |
||||
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 |
![]() |
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 |
![]() |
mariur89 | Excel | 4 | 12-14-2014 01:33 AM |