How To Return A Dollar Value As A Text String

Hi, I received an interesting request, involving VBA and how to return a stock price dollar value in a text character string rather that actual numbers.

Like (I=1,M=2,E=0) instead of showing cost price is 12.00
it shows IM.EE.

Kind of like code returning a special code.

Well, here is my rendition of it. It may help a few of you all. Of
course there are different ways to do this depending on the person. So, ACTUAL IMPLEMENTATIONS PROBABLY WILL VARY!

Free! Subscribe To Our YouTube Channel!

facebooktwittergoogle_plusredditpinterestlinkedinmailby feather
Tags:




 

Call Erik Now