changing format of number

Posted by jayakumar on December 12, 2000 10:03 AM

hello,

i am using ms excel 2000 i want to display values in LAKHS, e.g my value is 3,14,542 and i want to display as 3.14 in the cell

i tried using #, but it takes for 3 digits at a time and i can not customize it. pls. help

Thanks in advace.
regards,

jayakumar.

Posted by Celia on December 12, 2000 3:03 PM

Custom format :- #"."00,;-#"."00,

Also, macro to convert cells to above format :-
Sub ConvertToLahks()
Dim cell As Range
Application.ScreenUpdating = False
For Each cell In Selection
If IsNumeric(cell) Then _
cell.NumberFormat = "#"".""00,;-#"".""00,"
Next
End Sub

Celia