Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-19-2020, 01:18 AM
Naveen Dhanaraj Naveen Dhanaraj is offline Express Mergefield Number as Text Windows 10 Express Mergefield Number as Text Office 2019
Novice
Express Mergefield Number as Text
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default Express Mergefield Number as Text

How could I convert Currency in to words without VBA.... I want achieve this with a formula....




Amount Field Name: PAYMENTVALUETOTAL



Like this,
"$1,000.23", I need it like "One thousand dollars and twenty three cents"


how could I achieve this via formula...


Thanks,
Naveen
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mergefield - Replace Prefix of Document Number boonlailee Mail Merge 13 06-13-2019 04:38 PM
Express Mergefield Number as Text Word MergeField Code Text issue stevenel Mail Merge 17 09-27-2018 09:12 PM
Express Mergefield Number as Text Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM
Omit mergefield if it contains specific text MikeStewart Mail Merge 3 10-01-2014 01:31 AM
Express Mergefield Number as Text IF statement just generates text "MERGEFIELD" in document - what am I doing wrong? Eri Mail Merge 1 03-03-2012 03:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:29 PM.


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