| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
decimals and oracle
"Joel" ha scritto nel messaggio ... Sub test() MyNumber = "100.000,00" location_period = InStr(MyNumber, ".") location_comma = InStr(MyNumber, ",") If location_comma location_period Then MyNumber = Replace(MyNumber, ".", ";") MyNumber = Replace(MyNumber, ",", ".") MyNumber = Replace(MyNumber, ";", ",") End If Not correct, if number is "100,000,00" ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
decimals and oracle
The new code will work under ANY case. I originally solved the problem as
you posted it. "Nicolas Cage" wrote: "Joel" ha scritto nel messaggio ... Sub test() MyNumber = "100.000,00" location_period = InStr(MyNumber, ".") location_comma = InStr(MyNumber, ",") If location_comma location_period Then MyNumber = Replace(MyNumber, ".", ";") MyNumber = Replace(MyNumber, ",", ".") MyNumber = Replace(MyNumber, ";", ",") End If Not correct, if number is "100,000,00" ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count digits before decimals and after decimals | Excel Worksheet Functions | |||
| Numeric formatting: decimals and no decimals | Excel Programming | |||
| SQL for Oracle | Excel Discussion (Misc queries) | |||
| SQL for Oracle | Excel Discussion (Misc queries) | |||
| Connect to Oracle using Microsoft ODBC for Oracle | Excel Programming | |||
Linear Mode
