Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number formatting with VBA - Problem when used in different Country.
I need an urgent help.
I am working in India. My customer is in Germany. In India DOT (.) is used as decimal seperator. eg 3.589 In Germany COMMA (,) is used as decimal seperator. eg 3,589 in my code I used the following line for formatting. ' ******** With Selection.NumberFormat = "0.00" ' ******** Its working fine in India. But its not working in Germany. I tried to change MY EXCEL settings to the German way. I went to OPTIONS and modified the decimal seperator as COMMA (,). But with the same code, that is working. Now I am confused, how to handle this. Hope any of you has any clue on this. Pls help. Thank you. Regards / Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
typing 'Up Country' ends up as Up Country' ? | Excel Discussion (Misc queries) | |||
Show Country Name in Each Row | Excel Worksheet Functions | |||
Counting number of rows with Cond. Formatting to avoid save problem (KB 215783) | Excel Programming | |||
country list | Excel Discussion (Misc queries) | |||
Format the Cell into a telephone number but using country code | Excel Discussion (Misc queries) |