>
> Your Date is not date but to convert a date to number you can simply
> multiply it with one this scenario works most of the cases but not for all.
>
For Example your date is in A1 put formula in b1 = A1*1
Regards,
Mandeep baluja
ticket closed
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Dear sir
I cannot understand kindly brief/example
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 6:15 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Re: Help Required
Multiply date
Multiply date with 1
On Thursday, January 14, 2016 at 5:54:19 PM UTC+5:30, neeraj chauhan wrote:
>
> Dear sir,
>
>
>
> Thanks sir !!
>
> Kindly share the formula.
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Mandeep Baluja
> *Sent:* Thursda
Dear sir,
Thanks sir !!
Kindly share the formula.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 4:50 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help Required
PFA !! Ticket close
[mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Anand Tiwari
> *Sent:* Tuesday, August 04, 2015 4:24 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ RE: Help required
>
>
>
> Hi Neeraj
>
>
>
> Please use this,
>
Thanks Anand
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Anand Tiwari
Sent: Tuesday, August 04, 2015 4:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: Help required
Hi Neeraj
Please use this,
Alt+D+E then
Hi Neeraj
Please use this,
Alt+D+E then Delimited next click Date and choose format DMY then finish.
*Regards,*
*Anand Tiwari*
On 4 August 2015 at 16:14, Neeraj Chauhan
wrote:
> Dear experts I want to change the date format
>
>
>
> Date
>
> I want this format
>
> 31/7/2015
>
> 31-Jul-15
>
Thanks sir
its working and I want this
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Wednesday, May 20, 2015 3:25 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Help Required
Want this ?
Regards,
Mand
Glad to help :)
Regards,
Mandeep Baluja
Email :-mandeep.bal...@snapdeal.com
mandeep.bal...@gmail.com
https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77
https://www.facebook.com/groups/825221420889809/
On Wednesday, May 6, 2015 at 12:28:39 PM UTC+5:30, rk sharma wrote:
>
> Thanks alot Mandee
Thanks alot Mandeep ji.
its working.
br//
rakesh
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, INDIA
Phone 01912477440/ 01912477473/441
Fax 01912477442
Mobile +91 9906115140
rakesh.kumar.d.sha...@ericsson.com
www.ericsson.
when you select your blank cells just see the buttons in home tab where
insert,delete,format button is showing you need to press delete ->delete
cells -> shift cells to left .
On Wednesday, May 6, 2015 at 12:17:59 PM UTC+5:30, rk sharma wrote:
>
> Thanks Mandeep ji,
>
> but dear i didn't und
Thanks Mandeep ji,
but dear i didn't under stand what your are talking about this line
*go into home tab delete cells and shift cells left you will get your data*
Pl help
RAKESH SHARMA
NPI –Team
Ericsson India Pvt. Ltd.
4th Floor, Gupta Towers, Commercial Block, Rail Head
Jammu & Kashmir, IND
Ok Sir, I am trying.
Regards
Ashu Kenith
--
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 title
Dear Mandeep Sir,
All are enabled.
PFA the attachment.
Please provide Support.
Regards
Ashu Kenith
--
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 RULE
in this attachment did you enabled this library in refrences go to vba
editior enalble these library and then go to sheet1 and click the button
send mails .
microsoft outlook 14.0 object library
ole auotmation
microsoft excel 14.0 object library
visual basic for applications
microsoft forms 2.
Dear Mandeep Sir,
Query is still pending from last 2 months. Last time you said that,
you will send the answer shortly.
Revert awaited from your side.
Please help.
Regards
Ashu kenith.
On 1/15/15, Ashu k wrote:
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
P
Dear Mandeep Sir,
Please help.
kindly send the macro.
Regards
Ashu Kenith.
On Thu, Jan 15, 2015 at 6:41 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Please Help on the same issue. Can i explain again my query.
>
> Please help sir.
>
> Regards
> Ashu Kenith
>
> On Thu, Jan 15, 2015 at 12:30 PM, A
Dear Mandeep Sir,
Thanks a lot for your help.
I don't have an facebook account. So, request you to please share the macro
when you have time.
Thanks for your help and kind support.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 9:33 PM, Mandeep Baluja
wrote:
> https://m.facebook.com/VBAEXCELSQL
https://m.facebook.com/VBAEXCELSQL?__tn__=C
This is my page i have posted your macro on this blog top post is yours,
Copy the same and run in your sheet.
Sorry i forgot to send you the sheet.will send the same as i will be in office.
Regards,
Mandeep
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
Please help sir.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 12:30 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Please help.
>
> Regards
> Ashu Kenith.
>
>
> On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote:
>
>> Dear M
Dear Mandeep Sir,
Please help.
Regards
Ashu Kenith.
On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Thanks a lot for your help.
>
> one more help required.
>
> If the Merchant ID is same then paste the data (Order No., Item ID, Item
> Name, RTO Date) on mail body which w
Dear Mandeep Sir,
Thanks a lot for your help.
one more help required.
If the Merchant ID is same then paste the data (Order No., Item ID, Item
Name, RTO Date) on mail body which was belongs to Same Merchant ID.
Example : - Merchant ID is 12345 and 10 orders is placed by this merchant,
then pas
Dear Mandeep Sir,
Please Help.
Regards
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
>
> This is to inform you that as p
Dear Mandeep Sir,
Please Help!!
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
>
> This is to inform you that
Dear Mandeep Sir,
Solution was perfect. But i want Paste the data in Mail body.
Please check below sample Email :-
Dear Business Partner,
This is to inform you that as per our logistic partner report you have
received RTO shipments with details as follow:
*Order No*
*Item ID*
*Item Name
Dear Mandeep Sir,
I don't want to send mail with attachment. I want send different mail to
different customers according to the merchant ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch the merchant
id,order n
Dear Anil Sir,
Thanks for your reply. But, i dont want to send mail with attachment. I
want send different mail to different customers according to the merchant
ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch
Dear Mr. Ashu,
Pls find attached as per you requirement.
P.S pls change the address of the attachment as you req.
.Add ("T:\Commercial\Common\Shailendra\Data" & Format(Now(),
"mm-dd-yy") & ".xls")
Warm regards,
Gawli Anil.
On Wed, Jan 7, 2015 at 1:24 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
Dear Mandeep Sir,
PLease help. I want send mail to the customers. Example is attached.
Thanks
Ashu Kenith
--
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
Dear Paul Sir,
Thanks for your help and explaining me..
Dear Mandeep Sir,
Thanks a lot for your help, Please check the attached sheet. Result was not
showing in Last cell.
Please help.
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 10:21 AM, Mandeep Baluja
wrote:
> Hey Ashu,
>
>
> Check this sh
Dear Mandeep Sir,
It gives NA# again. Kindly run macro and See the result in Cell C1 and C12.
Sheet attached.
Thanks
Ashu Kenith
On Tue, Dec 23, 2014 at 10:52 AM, Mandeep Baluja
wrote:
> Now this macro works for 3 lakh rows you can increase the range as per
> your convenience.
>
> Regards,
>
Dear Mandeep Sir,
It's not working.
Thanks
Ashu Kenith.
On Thu, Dec 18, 2014 at 8:00 PM, Ashu k wrote:
>
> Dear Mandeep Sir,
>
> The code which is provided by you is not working properly. It's giving NA#
> in sheet 2.
>
> Formula is working fine for me which is provided by Ashish Sir & Vaibhav
Dear Mandeep Sir,
The code which is provided by you is not working properly. It's giving NA#
in sheet 2.
Formula is working fine for me which is provided by Ashish Sir & Vaibhav
Sir.
Kindly check the output and Please Help me.
Sheet attached.
Thanks
Ashu Kenith
On Thu, Dec 18, 2014 at 12:42 P
Dear Sir,
Thank you very much.
Thanks
Ashu Kenith
On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja
wrote:
>
> check this out.
>
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
> On Wednesday,
Hi
You can format cell as DD-Mmm- or
you can use formula =text(ref,"DD-Mmm-) where ref is your reference
cell.
Thanks
On Thu, Mar 27, 2014 at 4:52 PM, Neeraj Chauhan
wrote:
> Dear experts,
>
>
>
> We have given below date format how to convert right format of date like
> 13-Jan-2014
No it's not, that file protected by simple method to prevent user
opening it they change the file header structure
Try attached DBF, i've repair the header by changing 1st byte on file
with correct value.
Pada 11/09/2013 21:19, Basole menulis:
Hi, the dbf attachment is corrupted.
Em quart
Hi Cheer,
Please use the same mail chain for solution instead of new mail.
Aamir Shahzad
On Fri, Nov 2, 2012 at 5:21 PM, CoRe wrote:
> Hello Neeraj
>
> CTRL+1 on the value column --> Custom --> select type *0.00*
>
>
> cheers
>
>
> On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauhan
Hi Cheer,
Please use the same mail chane for solution instead of new mail.
Aamir Shahzad
On Fri, Nov 2, 2012 at 5:21 PM, CoRe wrote:
> Hello Neeraj
>
> CTRL+1 on the value column --> Custom --> select type *0.00*
>
>
> cheers
>
>
> On Friday, November 2, 2012 2:10:58 PM UTC+2, neeraj chauha
Core. Please REPLY to messages instead of creating a new one.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: CoRe
Sent: Wednesday, May 16, 2012 4:57 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: help required for creating a formula
Hello,
P
Dear Ashish
PFA
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Wed, May 16, 2012 at 3:27 PM, CoRe wrote:
> Hello,
>
> PFA!
>
>
>
> On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote:
>>
>> Dear All,
>>
>> I have a list of industry in one column and in cor
Hi,
I have attached a spreadsheet which contains list of document numbers and
their respective names. What I want is I need a word macro that will do the
following.
Note:
The file name will always starts with the Doc Number (5 digits). Ex: 12345
(Refer "Sample_Findlaw.xls" for list of Doc Number
Hi,
This is what I actually looking for. It works great and solves my query.
Thanks for your efforts and help.
Regards,
Sharma
On Sun, Oct 31, 2010 at 4:11 AM, roberto mensa wrote:
> the sub test is just one example of how to use the function into a routine.
>
> Sub test()
> Dim s As String
>
the sub test is just one example of how to use the function into a routine.
Sub test()
Dim s As String
s = "AGREEMENT. THE ADOPTION THE ADULT OR MARRIED MINOR "
s = ProperCase_r(s)
Debug.Print s
End Sub
r
--
--
Some
Hi,
I meant to say every time I need to change the "S" value as Input which is
taking more time.
I am unable to copy the result since it is showed via message box. I want to
copy the result and updated in documents.
It would be helpful if you could change the code as per the need.(Macro have
to
I don't understand
which linguage do you use?
In visual basic as I have proposed is a function you can pass any text and
use its result
regards
r
2010/10/28 amrahs k
> Hi,
>
> This works great. Thanks for your efforts and help. Though I have a small
> need as well.
>
> The code gives the ou
Hi,
This works great. Thanks for your efforts and help. Though I have a small
need as well.
The code gives the output through message box. Due to this I am unable to
copy the value (i.e) Output.
Also the code is only execute for the input "AGREEMENT. THE ADOPTION THE
ADULT OR MARRIED MINOR". Wha
46 matches
Mail list logo
