Text to Num

[#1]

I get a table form a site

http://www.tititudorancea.com/z/euro_to_usd_exchange_rates_dollars.htm

I get text and numbers in the table Dollar

How can i get the text into Num?

[#2]

Use the Num# function to convert text to number.

[#3]

hi,

probably you can use num(Dollar) to convert text to numbers.

thanx

[prabhu0505]

In properties dialog box of all the sheet object, you can find Number tab where you can override the document's default data type.

[prabhu0505]

another thought and also this seems to be closer

dual
Date# (text [, format])

[#6]

i got this now

but this isn't what I want

LOAD

Date,

textbetween

(Date,', ',',') as datum,

num#

(Close,'#0,##',) as dollar

FROM

[http://www.fxstreet.com/forex-tools/rate-history-tools/?days=15&pair=eurusd]

(

html, codepage is 1252, embedded labels, table is @2)

;