Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Issue regarding Regional settings
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel not using regional settings | Excel Discussion (Misc queries) | |||
Regional settings | Excel Worksheet Functions | |||
Regional Settings with Date | Excel Discussion (Misc queries) | |||
regional settings | Excel Worksheet Functions | |||
Regional Settings | Excel Discussion (Misc queries) |