Using Left function to format a range

		Microsoft Office Forums > Microsoft Excel > Excel
Using Left function to format a range

FAQ

Thread Tools

Display Modes

09-10-2015, 12:11 AM

macropod

Windows 7 64bit Using Left function to format a range

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

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]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clearing format and its effect on background color or a range, Excel 2010	Aria	Excel	0	11-03-2014 11:21 PM
#REF! Error in calling VBA function disappears when function is copied	lcaretto	Excel Programming	2	05-26-2014 07:19 PM
Find and Replace function shooting off screen to the left of the document	Mattblack	Word	1	04-10-2014 03:06 PM
Converting a left to right doc to a right to left	seli	Word	3	04-23-2012 11:39 PM
Change format of date when using Now function in VB code	Bondai	Excel Programming	2	03-02-2012 05:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:57 AM.