Thread: [Solved] Using Left function to format a range
View Single Post
 
Old 09-10-2015, 12:11 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,365
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
If your reference cells contain actual dates and you're concerned to match those containing 30/6/2015, you will need to test the numeric value of that date (42185), not its formatted representation.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote