Sir thanks for reply.
But sir... For Only few rows not get corrected.. Rest things are
perfects...why this so.
Regard,
Prafull Jadhav.
9920553518
On 19-Nov-2013 12:03 AM, "ashish koul" wrote:
> is it 1 apr 2013
>
> try to change the setting of ur computer control panel - regional setting
> -
is it 1 apr 2013
try to change the setting of ur computer control panel - regional setting
- choose English USA then try the macro
Regards
Ashish
On Mon, Nov 18, 2013 at 1:18 PM, Prafull Jadhav wrote:
> DEAR RAJAN SIR,
>
> thanks for reply...
> but output showing jan and feb month also afte
DEAR RAJAN SIR,
thanks for reply...
but output showing jan and feb month also after running macro .
Regards,
Prafull Jadhav
9920553518
On Mon, Nov 18, 2013 at 12:32 PM, Rajan sharma wrote:
> Hi, Try using below:
>
> Sub prafu()
> For Each x In Range("A1:A9000")
> x.Value = Format(x.Value
Hi, Try using below:
Sub prafu()
For Each x In Range("A1:A9000")
x.Value = Format(x.Value)
x.Value = Format(x.Value, "dd-mm- hh:mm")
Next x
End Sub
With warm regards,
Rajan Sharma
On Mon, Nov 18, 2013 at 12:23 PM, Prafull Jadhav
wrote:
> Dear All,
>
> Good Afternoon !
> I have on
