Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-28-2019, 08:57 PM
macropod's Avatar
macropod macropod is offline Macro to read years into words Windows 7 64bit Macro to read years into words Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See 'About field code syntax' in:


https://support.office.com/en-us/art...4-bab6ba6b06bb
and 'Number formats' in:
https://support.office.com/en-us/art...f-6c36ae43508c
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 01-28-2019, 11:47 PM
Marcia's Avatar
Marcia Marcia is offline Macro to read years into words Windows 7 32bit Macro to read years into words Office 2007
Expert
Macro to read years into words
 
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you again Paul for the link that you provided. After more than an hour of trial and error, I finally got the hang of applying the CardText switch. My problem is that the result shows "One Thousand Nine Hundred Thirty Nine" when it should be "Nineteen Hundred Thirty Nine". I will ask our Vicar if this is okay.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to read years into words Use macro on form activate attached to read only file smarti Word VBA 3 03-02-2017 09:06 AM
Macro to read years into words Macro to read cell contents and compare data jrfoley3 Excel Programming 7 07-09-2016 12:25 PM
Macro to read years into words Macro will not read the value of cell with a formula in it! grayson1231 Excel Programming 10 03-28-2015 03:47 PM
Email macro to read range for .To field MattMurdock Excel Programming 2 08-07-2012 06:46 AM
Macro to read years into words Macro to read word document harishankar.selvaraju Excel Programming 1 06-14-2012 03:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:51 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