sometimes from a query of oracle i get an excel report with funny numbers
in text format like "100.000,00" instead of "100.000,00"

Oracle admin says Oracle spoil many times the data and i need to correct it
by code
Any idea?

Tia

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


End Sub


"Nicolas Cage" wrote:

> sometimes from a query of oracle i get an excel report with funny numbers
> in text format like "100.000,00" instead of "100.000,00"
>
> Oracle admin says Oracle spoil many times the data and i need to correct it
> by code
> Any idea?
>
> Tia
>
>
>

"Joel" <(E-Mail Removed)> ha scritto nel messaggio
news:5CE7A700-3F94-4BFF-9493-(E-Mail Removed)...
> 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" ?

The new code will work under ANY case. I originally solved the problem as
you posted it.

"Nicolas Cage" wrote:

>
> "Joel" <(E-Mail Removed)> ha scritto nel messaggio
> news:5CE7A700-3F94-4BFF-9493-(E-Mail Removed)...
> > 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" ?
>
>
>