Re: $$Excel-Macros$$ Need Help

2014-06-13 Thread Divaker Pandey 
you can use pivot table option


On Fri, Jun 13, 2014 at 1:23 AM, Imran Khan  wrote:

> Dear All,
>
> I need your help to summarize the sheet. I have attach the file as an
> example. I am looking formula to summarize matching with T1A, T1R & T2 from
> Data sheet.
>
> Please help me.
>
> I applogise for file size 460KB as i am trying to reduce, but i am unable.
>
> Thanks & Regards,
>
> *Imran Khan*
>
> *Lead Planner - OR/CSU*
>
> Ras Al-Khair Industrial City
>
> P.O. Box 11342, Jubail Industrial City – 31961,
>
> Saudi Arabia
>
> Mobile Phone: +966-555160349
>
> Email : kha...@mac.maaden.com.sa
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

RE: $$Excel-Macros$$ Re:Date conversion

2014-06-13 Thread Ravinder 
Try below
=TEXT(DATE(RIGHT(B14,4),MID(B14,4,2),LEFT(B14,2)),"DD-MMM-YY")

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Mohd Sanusi Mohd Noor
Sent: Friday, June 13, 2014 2:56 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re:Date conversion

Dear experts,

For info, I've an issue on the conversion of date format.
Referring to the attached worksheet, what is the best way to convert date 
format from A to B type.

Your feedback of the above is highly appreciated.

Best regards

Sanusi

--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re:Date conversion

2014-06-13 Thread Mohd Sanusi Mohd Noor 
Dear Ravinder,

Thank you very much.
It works well.

Best regards

Sanusi

On 13 June 2014 17:30, Ravinder  wrote:
> Try below
> =TEXT(DATE(RIGHT(B14,4),MID(B14,4,2),LEFT(B14,2)),"DD-MMM-YY")
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
> Behalf Of Mohd Sanusi Mohd Noor
> Sent: Friday, June 13, 2014 2:56 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Re:Date conversion
>
> Dear experts,
>
> For info, I've an issue on the conversion of date format.
> Referring to the attached worksheet, what is the best way to convert date 
> format from A to B type.
>
> Your feedback of the above is highly appreciated.
>
> Best regards
>
> Sanusi
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups "MS 
> EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups "MS 
> EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

2014-06-13 Thread Vaibhav Joshi 
This one is whole mail body as required by you..


On Tue, May 20, 2014 at 5:07 PM, Vaibhav Joshi  wrote:

> Hi
>
> PFA..
>
> You can change it to as per your need.
>
> Cheers!!
>
>
> On Tue, May 20, 2014 at 4:33 PM, khagesh khera 
> wrote:
>
>> Dear Expert,
>>
>> I am working with an MNC & the database is so huge. We required to send
>> the auto emails to client with same format.
>>
>> The outstanding details need to mentioned on the body text only which is
>>  not happening with this macro.
>>
>>
>>
>> Regards,
>> Khagesh Khera
>>
>> On Thursday, 7 April 2011 10:35:14 UTC+5:30, ashish wrote:
>>>
>>> try this
>>>
>>> On Thu, Apr 7, 2011 at 9:10 AM, Hairkesh Kumar 
>>> wrote:
>>>
 Hi Experts,


 We required your help for creat auto mailer in excel. or any other way,

 I have to send 200 mails with different attachment. can we creat auto
 mailer in excel thourgh macros.

 Please help me out.

 Thanx in Advance .


 Regards
 Harkesh

>>>
>>>
>>>
>>> --
>>> *Regards*
>>>
>>> *Ashish Koul*
>>> *akoul*.*blogspot*.com 
>>> *akoul*.wordpress.com 
>>> My Linkedin Profile 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


send range in sheet as email .xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Urgent required .NET Developer - Redmond, WA

2014-06-13 Thread Gary . 
*Please respond to gurjant.si...@damcosoft.com
*



*Position: .NET Developer Location: Redmond, WADuration: 6-12 Months*

Job Description:
The successful candidate will be responsible for maintaining and improving
an existing data processing engine for warehousing audio and textual data
samples.  The candidate will analyze the needs of the teams linguistic
developers and determine the best way in which to meet their data needs.
This position will require close collaboration between the developers and
managers, so the candidate must work well in a team environment.

Key Technical Skill: C#, SQL Server

Desired Skills: Entity Framework SQL Development, Audio File Processing and
Format familiarity, XML serialization and methodology

Experience Level: 5+ years



Thanks and Regards,



Gurjant Singh - (Gary)

Technical Recruiter

+1 212 389 9503 ext 208

E: gurjant.si...@damcosoft.com



*NY Office:  *112 W 34th St, 18th Floor, New York, NY 10120

*NJ Office:  *894 Green Street, Suite B, Iselin, NJ 08830



Corporate: www.damcosoft.com

*[image: Description: cid:image002.jpg@01CEDAE3.C3BE19D0]*



*[image: Description: cid:image006.jpg@01CEDAE5.F56ED350]*



*P** Please consider the planet before printing | Switch off as you go
|**q**Recycle
always |* *Your child deserves a better world*

*CONFIDENTIALITY NOTICE:** This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all copies
of the original message*

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Macro Data entry by row and column search

2014-06-13 Thread Michael Kohl 
 

*Paul, *

 

*Thank you so much for the work you did. Clearly you have a lot of talent 
and experience since I have been digging through this for a few hours and I 
was only able to make minor modifications. So I figured I would ask you 
some more questions and save the time digging into this deeper and watching 
other videos.*

 

*For my column and row headers the actual headers are more than 1 digit in 
length. I noticed that your error checker runs after 1 field is totally 
filled out it runs the moment I type in the first letter or number in the 
second field. Is there a way to delay that error checking until after the 
Unit# and mfg step are entered completely?  Example: Unit# = 500 mfg step = 
2590. The program returns an error the moment I enter ‘2’ then again when I 
enter ‘5’ and again when I enter ‘9’  then when I enter the last 0 it 
returns no error since that step is a header. *

 

*Also is it possible to build in another box in the input window which 
displays todays date. Maybe just something on the top. *

 

*I was able to add some buttons and other functionality but clearly I am 
very new at this. I see in the code where you have the error checking built 
in and I tried to delete the if statements that were driving the error 
checker. But that didnt change when the checker is ran. *

 

*You are the man Paul! Where are you from? *

 

*Thanks again!*


On Thursday, June 12, 2014 2:55:36 PM UTC-7, Michael Kohl wrote:
>
>
> Paul,
>
> Thank you so much for this. This is exactly along the lines I am looking 
> for. I love the error protection you built into the sheet.
>
> I know little about excel Macros however i do have some coding experience 
> and can pick up on what you are doing. I will mess around with it some more 
> tonight and tomorrow morning and e-mail you with any questions. 
>
> Thank you so much for your quick response. Its amazing to see so many 
> outstadning people willing to share their knowledge with the world! 
>
> On Thursday, June 12, 2014 6:34:46 AM UTC-7, Paul Schreiner wrote:
> ABSOLUTELY possible...
>
> and a variety of solutions.
>
> How conversant are you with VBA and userforms?
>
> Here's what I would do: 
> I would create a userform that:
> Upon opening, it loads data into a Dictionary Object
> (MUCH easier to index than an array)
>
> Then, once the Unit and Step are entered, retrieve the data from the table.
> If the user overwrites the value, prompt for approval.
>
> In the attached file, the userform is opened by Double-clicking cell A1.
>
> If you REALLY wanted to, you could lock all the cells, and protect the 
> document
> (Except for Cell A1)
> then, the user can ONLY update using the userform.
> In the macro, you would then unprotect the document, make the change, then 
> re-protect.
>
> I threw this together pretty quickly
> (in about 40 minutes between phone calls and emails plus one trip for 
> coffee)
>
> I didn't spend much time (if any) documenting the code, so if you have 
> trouble following it, let me know.
>
>
>
>
> Paul
> -
> “Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> -
>
>
>
>
>
>
> From: Michael Kohl 
> To: excel-...@googlegroups.com 
> Sent: Wednesday, June 11, 2014 6:41 PM
> Subject: $Excel-Macros$ Macro Data entry by row and column search
>
>
>
> Looking for some help with a macro to run a couple operations. Here is the 
> low down of what I am trying to accomplish. 
>
> I have a sheet with 16 columns and about 500 rows. The first column 
> contains row headers for the unit number (1-500). the first row contains 
> the column headers for 15 steps in manufacturing.(call it A-O for example). 
> Here is an example.
>
> A B C D E F G H I J K L M N O 
> 1 100 874 454 456 525 
> 2 101 845 584 588 651 
> 3 103 654 215 
> 4 359 
> 5 658 489 685 
> 6 542 
> 7 658 2354 
> 8 
> 9 
> 10 https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to e

Re: $$Excel-Macros$$ Date Format Query

2014-06-13 Thread Pravin Gunjal 
Dear Pramod,

Thank you for your reply.  But I found it is not giving result for all
cells.
Please do the needful.


On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh  wrote:

> Hi
> Pravin Gunjal,
>
> PFA
>
> Hope This will fine for you..
>
>
>
>
> Warm Regards
>
> Pramod
>
> VBA Developer
>
>
> On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal  wrote:
>
>> Hi,
>>
>> I wanted to convert the dates in this format *DD.MM.*
>>
>> Now it is not in system's date format ( MM/DD/ ) and it is displayed
>> as DD/MM/ or as D/M/.
>>
>> Kindly help.
>>
>> Regards
>> Pravin Gunjal.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>>
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> *PramodSingh*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to a topic in the
> Google Groups "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/excel-macros/KuYWzt64SjI/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Date Format Query

2014-06-13 Thread Pramod Singh 
Where have not applying this date format.. Can send u file with mark
area

Pramod
On 14 Jun 2014 10:41, "Pravin Gunjal"  wrote:

> Dear Pramod,
>
> Thank you for your reply.  But I found it is not giving result for all
> cells.
> Please do the needful.
>
>
> On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh  wrote:
>
>> Hi
>> Pravin Gunjal,
>>
>> PFA
>>
>> Hope This will fine for you..
>>
>>
>>
>>
>> Warm Regards
>>
>> Pramod
>>
>> VBA Developer
>>
>>
>> On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal  wrote:
>>
>>> Hi,
>>>
>>> I wanted to convert the dates in this format *DD.MM.*
>>>
>>> Now it is not in system's date format ( MM/DD/ ) and it is displayed
>>> as DD/MM/ or as D/M/.
>>>
>>> Kindly help.
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> *PramodSingh*
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to a topic in the
>> Google Groups "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/excel-macros/KuYWzt64SjI/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://ww