1. How can I format a cell or range of cells so that the actual figure I
entered will
get automaticall converted in lakhs e.g. the actual figure 64646587.646664
entered in A1 cell should convert in lakhs as 6464.6587646664.

2. How can I make Excel to move along the cell A1, A2, A3 (press Enter
button)then B1, B2, B3 (press Enter button) then C1,C2, C3 and so on..

Ajit
--
Knowldege is Power

1.
Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then
With Target
.Value = .Value / 10000
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


2. See

http://www.xldynamic.com/source/xld.xlFAQ0008.html
Excel FAQs - TAB To Selected Cells

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ajit Munj" wrote in message
...
1. How can I format a cell or range of cells so that the actual figure I
entered will
get automaticall converted in lakhs e.g. the actual figure 64646587.646664
entered in A1 cell should convert in lakhs as 6464.6587646664.

2. How can I make Excel to move along the cell A1, A2, A3 (press Enter
button)then B1, B2, B3 (press Enter button) then C1,C2, C3 and so on..

Ajit
--
Knowldege is Power

Thanks Bob! its working. Will you please solve my second questin i.e. movement
of cells?
Ajit

"Bob Phillips" wrote:

1.
Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then
With Target
.Value = .Value / 10000
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


2. See

http://www.xldynamic.com/source/xld.xlFAQ0008.html
Excel FAQs - TAB To Selected Cells

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ajit Munj" wrote in message
...
1. How can I format a cell or range of cells so that the actual figure I
entered will
get automaticall converted in lakhs e.g. the actual figure 64646587.646664
entered in A1 cell should convert in lakhs as 6464.6587646664.

2. How can I make Excel to move along the cell A1, A2, A3 (press Enter
button)then B1, B2, B3 (press Enter button) then C1,C2, C3 and so on..

Ajit
--
Knowldege is Power

I gave you a link that addresses that matter.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ajit Munj" wrote in message
...
Thanks Bob! its working. Will you please solve my second questin i.e.
movement
of cells?
Ajit

"Bob Phillips" wrote:

1.
Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range("A1:H10")) Is Nothing Then
With Target
.Value = .Value / 10000
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.


2. See

http://www.xldynamic.com/source/xld.xlFAQ0008.html
Excel FAQs - TAB To Selected Cells

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ajit Munj" wrote in message
...
1. How can I format a cell or range of cells so that the actual
figure I
entered will
get automaticall converted in lakhs e.g. the actual figure
64646587.646664
entered in A1 cell should convert in lakhs as 6464.6587646664.

2. How can I make Excel to move along the cell A1, A2, A3 (press
Enter
button)then B1, B2, B3 (press Enter button) then C1,C2, C3 and so on..

Ajit
--
Knowldege is Power