ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Decimals problem (https://www.excelbanter.com/excel-programming/380576-re-decimals-problem.html)

[email protected]

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