![]() |
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 |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com