View Single Post
 
Old 10-14-2019, 09:04 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
Expert
 
Join Date: Aug 2014
Posts: 3,191
gmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of lightgmayor is a glorious beacon of light
Default

Quote:
Originally Posted by bbhe View Post
The Date seems to still be in dd-mm format and not dd/mm also after I click the red text
The date format is set in the line

oRng.Text = Format(DateAdd("ww", iNum - 1, DateSerial(Year(Now), 1, i)), "dd/mm")
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote