Re: $$Excel-Macros$$ date problem

2016-07-12 Thread GENIUS
I did this (custom formatting) in my computer but not working, actually I got this file from a system where the date format of the system was mm/dd/ -- 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

Re: $$Excel-Macros$$ date problem

2016-07-11 Thread Sant Ram
Just change custom formatting -- Select data range right click go to format cell go to customer in number tab paste this - dd/mm/ [image: Inline image 1] On Mon, Jul 11, 2016 at 10:54 AM, Izhar wrote: > Please open the file, I've given everything in the attach file > > -- > Are you =EXP(E:

Re: $$Excel-Macros$$ Date Problem

2012-05-09 Thread respuzy
Thanks Ross Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: "Asa Rossoff" Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 16:33:57 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Date Problem hilary, Inste

Re: $$Excel-Macros$$ Date Problem

2012-05-09 Thread respuzy
SARI > *Sender: * excel-macros@googlegroups.com > *Date: *Tue, 8 May 2012 23:58:01 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Date Problem > > Another approach.. > > * > =CHOOSE(MONTH(TODAY()),"Jan","Feb"

RE: $$Excel-Macros$$ Date Problem

2012-05-08 Thread Asa Rossoff
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sam Mathai Chacko Sent: Tuesday, May 08, 2012 1:00 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Problem Because today is the 5th month. And the value of 5 is actually equivalent to 5 da

Re: $$Excel-Macros$$ Date Problem

2012-05-08 Thread Sam Mathai Chacko
SARI > *Sender: * excel-macros@googlegroups.com > *Date: *Tue, 8 May 2012 23:58:01 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ Date Problem > > Another approach.. > > * > =CHOOSE(MONTH(TODAY()),"Jan","Feb","Mar

Re: $$Excel-Macros$$ Date Problem

2012-05-08 Thread respuzy
, 8 May 2012 23:58:01 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date Problem Another approach.. * =CHOOSE(MONTH(TODAY()),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","

Re: $$Excel-Macros$$ Date Problem

2012-05-08 Thread NOORAIN ANSARI
Another approach.. * =CHOOSE(MONTH(TODAY()),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") * -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, May 8, 2012 at 11:32 PM, hilary lomotey wrote: > Hello > > Pls i want to ge

Re: $$Excel-Macros$$ Date Problem

2012-05-08 Thread respuzy
Thanks Sam for the quick response. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Sam Mathai Chacko Sender: excel-macros@googlegroups.com Date: Tue, 8 May 2012 11:20:37 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date

Re: $$Excel-Macros$$ Date Problem

2012-05-08 Thread Sam Mathai Chacko
Just Use =TEXT(TODAY(),"mmm") Regards, Sam Mathai Chacko On Tue, May 8, 2012 at 11:02 AM, hilary lomotey wrote: > Hello > > Pls i want to get the month of today such as May but if i use this > formula TEXT(MONTH(TODAY()),"mmm") its evaluates to Jan, however if i > evaluate only MONTH(TODAY())

Re: $$Excel-Macros$$ Date Problem

2012-02-25 Thread Maries
Hi, Try this code, Sub datecorrection() On Error Resume Next Dim MyCell As Range For Each MyCell In Selection.Cells If IsDate(MyCell) Then Selection.NumberFormat = "m/d/" Else MyCell.Value = DateValue(Mid(MyCell, 5, 2) & "/"