Previous Topic Next Topic

Formating Dates

Closed
Cindy - Jul 26, 2016 at 11:30 AM
 Blocked Profile - Jul 26, 2016 at 04:48 PM
Hello,

I am trying to do a VLookup between to spread sheets and having a terrible time with the dates formatting correctly. Each spread sheet comes from a different program and put into excel one file is opened with a delimited format and the other is not. My problem is on one spread sheet the date shows as 06/27/2013 and in the delimited spread sheet is shows as 20130627. Can you tell me how I can format these so when doing our compare this will work.
Thank you,

1 response

Answer 1 / 1
Blocked Profile
Jul 26, 2016 at 04:48 PM
You can use date along side with Left(), MID(), and RIGHT().

See below!



0

Similar discussions

encryption message several time in chat
measking -
HelpiOS -

1 response
IF statements with dates and criteria
jimbabama -
Mazzaropi -

3 responses
blank white page for website
yadaves -
ac3mark -

1 response
using web browser page loads but screen blank
inchoate -
leo -

16 responses
using nested if to blank out adjacent cells
WILLYB -
mubashir aziz -

3 responses