View Single Post
 
Old 04-04-2020, 01:17 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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 !
Attached Files
File Type: xlsm deaths.xlsm (20.4 KB, 7 views)
Reply With Quote