Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimals problem
Have you tried using a period decimal (".") instead of comma decimal
(",")? 1.1 vs 1,1 --Paul excelent wrote: 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 ? 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 | |||
Count digits before decimals and after decimals | Excel Worksheet Functions | |||
problem with number format with 2 decimals? | Excel Worksheet Functions | |||
Decimals? | Excel Discussion (Misc queries) | |||
Problem formatting decimals in ComboBox | Excel Programming | |||
Fractions to Decimals problem | Excel Discussion (Misc queries) |