Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimal problems
I have found that IsNumeric is not too reliable, although not in the context
of non-US settings. You might try this instead: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("G:G")) Is Nothing Then If Not Application.IsText(ActiveCell.Value) Then If Left(ActiveCell.Formula, 1) < "=" Then Application.EnableEvents = False ActiveCell.Formula = "=" & ActiveCell.Value Application.EnableEvents = True End If End If End If End Sub -- Jim "excelent" wrote in message ... | This kode works fine when i put integer numbers like 1 or 11 or 13 | in column G, but if i put 1,1 or 1,11 or 12,2 it return an error why ? | (Excell 2003 DK) by the way input like 1.1 (1 dot 1) is text in DK way | | Private Sub Worksheet_Change(ByVal Target As Range) | If Intersect(Target, Range("G:G")) Is Nothing Then Exit Sub | If IsNumeric(Target) Then Target = "=" & Target | End Sub | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
Localisation decimal problems | Excel Programming | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |