I'm trying to take something that's a date code and change it to a date without having to manually enter almost 300 entries. Help.
It looks something like:
12AU14
I want to format it to be 8-12-14. Thanks!
I'm trying to take something that's a date code and change it to a date without having to manually enter almost 300 entries. Help.
It looks something like:
12AU14
I want to format it to be 8-12-14. Thanks!
You have to enter 12 entries -- the month abbreviations that you use.
Apart from AU, what's the rest?
Please click the * below if this helps
Try this (replace reds with your month abbreviations
Formula:Please Login or Register to view this content.
Last edited by hohlick; 09-12-2014 at 09:22 AM. Reason: error
Sorry, it took me so long to reply. So far I have five months entered. AP=April MA=May JU=June JY=July AU=August and so forth. JasperD does this answer what you were asking? It looks to me that the code will remain first two letters except JU and JY.
Thank you Hohlick I will try that tomorrow morning!
You can try on thing..
Try Find and replacing ..
Each month... ie "JA" with "-01-" and so on ( Without Quotes..)
I guess that will do the job...
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Or try this basic code for that...
This will do it automatically..Please Login or Register to view this content.
Although it is untested...
Last edited by Vikas_Gautam; 09-13-2014 at 02:20 AM.
What do you mean application input box?
So I would enter starting Sub replace month correct? I'm going to try this now.
will throw an Input Box where you will select the range you are gonna target for replacement...Please Login or Register to view this content.
And One important thing..
Before try the code.. CHANGE the date format of your Computer to DD-MM-YYYY because the position of "AU" is in the middle..
this will resist the month to become a day...
Last edited by Vikas_Gautam; 09-12-2014 at 11:34 PM.
I don't know how to find the input box in Excel 2010. I have already formated the cells.
No NewBie..
You don't need to find the InputBox..
its a vba code ("Macro" you know..)
Copy the code..
Go on to your excel sheet and Press ALT + F11
and INSERT a Module there ..
Paste the code there ...
press F5 to run the code....
Enter your targeted range..
click ok...
thats it..
Check the attached file..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks