Hello Friends, Following some additional clues I found to sort this issue & I think will need good macro to solve the problem. Step by step clues :
1) Identify the cells which have year 2000 & same cells should be converted
into "mm-yy" TEXT format.
2) Identify the cells which have mm-dd-yy format & same cells should be
converted into "dd-mm" TEXT format.
3) Remaining al cells should be remain UNCHANGED.
Formula I tried :
=IF(D7="","",IF(YEAR(D7)=2000,TEXT(D7,"mm-yy"),TEXT(D7,"dd-mm")))
But this is changing cells which are in correct format.
Please review.
Thanks & regards,
Suyog K
---------- Forwarded message ----------
From: Suyog Kulkarni <suyog.kulka...@yahoo.com>
Date: Tue, Nov 15, 2011 at 10:32 AM
Subject: $$Excel-Macros$$ Query on dd-mm & mm-yy format
To: excel-macros@googlegroups.com
Hello Friends,
Find attached excel file for ref.
I'm using one software which list out required material for structure in
excel. Output of that excel file converts some length of "Ft-In" format in
"mm-dd-yy or mm-yy" format.
Ex: For Length 10-11, excel shows Nov-11 & For length 11-10, excel shows
10/11/11.
Somehow I need to keep all length either in text format or in Ft-inch
format. I'm not importing file into excel so I can't fix the "text type"
for particular column.
Manual edition will be tedious as there are more than 75 pages (Each have
more than 1000 rows), If anybody can suggest any easy way to save time.
Thanks & regards,
--
*Suyog Kulkarni*
Mailto:-suyog.kulka...@yahoo.com
suyog.kulka...@hotmail.com
Ph:-( +91 ) 9890123539
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
Suyog Kulkarni
Mailto:-suyog.kulka...@yahoo.com
suyog.kulka...@hotmail.com
Ph:-( +91 ) 9890123539
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
3042.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
