Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decimal problems
What error do you get?
-- Kind regards, Niek Otten Microsoft MVP - Excel "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 | |
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 | |||
Decimal problems | Excel Programming | |||
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) |