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
3042.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
