-Macros$$ to remove time
Not much info but you can probably change the format.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA <mailto:vijayajith...@gmail.com>
Sent: Thursday, April 05, 2012 10:54 AM
To: excel-macros@googlegroups.com
S
Not much info but you can probably change the format.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Thursday, April 05, 2012 10:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ to remove time
Hi ,
12/2/2001 12:00 PM
HI Vijay,
You can use very simple formula '=int(your date)
Int is basically use for Rounds a number down to the nearest integer.
On Thu, Apr 5, 2012 at 9:24 PM, vijayajith VA wrote:
> Hi ,
>
> 12/2/2001 12:00 PM --- How to remove time ? i need only date .. is
> thr any formula ..Th
Thanks Noorain ... & Mareshwaran
On Thu, Apr 5, 2012 at 9:36 PM, NOORAIN ANSARI wrote:
> Dear Vijay,
>
> Please try it..after selection the required range..
>
> Sub remove_Time()
> Dim mycell As Range
> For Each mycell In Selection
> if vba.isdate(mycell) then
> mycell.Value = VBA.Left(mycell, VB
Dear Vijay,
Please try it..after selection the required range..
Sub remove_Time()
Dim mycell As Range
For Each mycell In Selection
if vba.isdate(mycell) then
mycell.Value = VBA.Left(mycell, VBA.InStr(1, mycell, " ") - 1)
Selection.NumberFormat = "m/d/"
endif
Next
End Sub
On Thu, Apr 5, 20
*Try it, =TEXT(INT(A1),"DD/MM/")*
On Thu, Apr 5, 2012 at 7:54 PM, vijayajith VA wrote:
> Hi ,
>
> 12/2/2001 12:00 PM --- How to remove time ? i need only date ..
> is thr any formula ..Thanks in advance
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use conci
