Thank you NOORAIN ANSARI
regards,
sanjib
On Tue, Nov 15, 2011 at 8:51 PM, NOORAIN ANSARI wrote:
> Dear Sajib,
>
> Please try it and see attached sheet..
>
> *Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> On Error Resume Next
> If ActiveCell.Column = 1 And IsNumeric(Active
Dear Sajib,
Please try it and see attached sheet..
*Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
If ActiveCell.Column = 1 And IsNumeric(ActiveCell.Offset(-1, 0).Value) =
True And Not IsEmpty(ActiveCell.Offset(-1, 0)) Then
ActiveCell.Offset(-1, 0).Value = A
Dear Mambers,
any body please help.
regards,
Sanjib
On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Members,
>
> In excel 2003 I want to put the value in the cell (A1) as 15.11. But
> while changing(i.e. press enter or tab)
> the cell I wan
Dear Ranjan Verma,
But I want I only put 15.11 in a cell, it will convert into 15.11.2011
Thanking you in advance
Sanjib
On Tue, Nov 15, 2011 at 2:12 PM, rajan verma wrote:
> HI,
> You can change Cell Format as you required like dd.mm or mm.dd
>
> On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Cha
HI,
You can change Cell Format as you required like dd.mm or mm.dd
On Tue, Nov 15, 2011 at 1:40 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Members,
>
> In excel 2003 I want to put the value in the cell (A1) as 15.11. But
> while changing(i.e. press enter or tab)
> the
Dear Members,
In excel 2003 I want to put the value in the cell (A1) as 15.11. But while
changing(i.e. press enter or tab)
the cell I want to convert the figure as 15.11.2011 and so on.
Thanking you in Advance
Regards,
Sanjib
--
-
--
FORUM RULES (934+ members already BANNED for viola
