$$Excel-Macros$$ Date Issue

2015-11-22 Thread Bill Q
PSA. Can someone please create a macro for me that would eliminate this frustrating problem that I have with date converstion. DATE1 = Source. It always gets imported in as 2 different date formats. DATE2 is what I want returned in a MMDD format. I have manually change it in this exampl

Re: $$Excel-Macros$$ Date Issue

2010-04-18 Thread Harsh Gharpure
Use the formula D5=text(C5,"mmm-yy") to display text in desired format. regards, Harsh On Wed, Sep 2, 2009 at 5:20 PM, Putta Madaiah wrote: > Hi Friends, > > I want a solution (Preferably formula) as expained in the attached sheet.. > > Thanks in Advance, > > Putta- Bangalore > > --~--~---

$$Excel-Macros$$ Date issue on a vba application

2009-09-07 Thread Alessandro
Hi all, I'm using Excel 2003 and I'm writing a simple VBA application which inserts single credit card expenses into a sheet and then updates - in the same sheet but in a different area - the total on a month basis. I have some problems in the month basis update because dates aren't managed corr