Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 04-04-2020, 01:17 PM
Logit Logit is offline Any method of formatting a cell that will return a number value with pronounceable text. Windows 10 Any method of formatting a cell that will return a number value with pronounceable text. 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
 

Tags
format numbers, pronounceable, text



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
Any method of formatting a cell that will return a number value with pronounceable text. 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
Any method of formatting a cell that will return a number value with pronounceable text. Search for multiple texts in cell, return specific text mariur89 Excel 4 12-14-2014 01:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft