CTRL+1 --->Custom format , choose the one you need.
--
FORUM RULES (986+ members already BANNED for violation)
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
ubject: $$Excel-Macros$$ to remove time
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 concise, accurate thread titles. Poor thread titles, like Pleas
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
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 concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code