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 prafulltjad...@gmail.comwrote:
DEAR RAJAN SIR,
thanks for reply...
but output showing jan and
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 koul.ash...@gmail.com wrote:
is it 1 apr 2013
try to change the setting of ur computer control panel -
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
prafulltjad...@gmail.comwrote:
Dear All,
Good
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 rajansharma9...@gmail.comwrote:
Hi, Try using below:
Sub prafu()
For Each x In Range(A1:A9000)
