T
T.Mad
Hi there,
I am programming in VBA having set up the Greek Regional settings. This
means that in Greece we use “,†instead of “.†for decimals and “.†instead
of “,†for thousands. I had to pass an excel formula via VBA which is:
Dim num as Double
Num=Cells(1,2).value ‘ this number is 10.1 (10,1 with Greek symbols)
Cells(1,1).formula = “=if(“ & num & “=0,0,5)â€
and I got an error message. I also used this formula:
Cells(1,1).formula = “=if(“ & num & “=0;0;5)â€
Which is the exact way to input the IF function ( to Excel with Greek
regional settings but again I got this error. Can anybody give me a good
piece of advice?
Many Thanks
I am programming in VBA having set up the Greek Regional settings. This
means that in Greece we use “,†instead of “.†for decimals and “.†instead
of “,†for thousands. I had to pass an excel formula via VBA which is:
Dim num as Double
Num=Cells(1,2).value ‘ this number is 10.1 (10,1 with Greek symbols)
Cells(1,1).formula = “=if(“ & num & “=0,0,5)â€
and I got an error message. I also used this formula:
Cells(1,1).formula = “=if(“ & num & “=0;0;5)â€
Which is the exact way to input the IF function ( to Excel with Greek
regional settings but again I got this error. Can anybody give me a good
piece of advice?
Many Thanks