How to get rid of text stored as number and not loose dot in number?

[jaryszek]

Hi Guys,

i am using this code to import text file:

Please Login or Register  to view this content.

everything is imported correctly but problem is that some columns are converted to a text. take a look in column B. "1" is store as text and i want to stored it as general.

And now to convert it i could use this code:

Please Login or Register  to view this content.

but problem is that it is converting "4.1" (in second row) into "4,1" ! What to do? How to avoid this?
Best,
Jacek

[Pete_UK]

I think the dot (or comma) has to do with your regional settings, so if you change these to UK or US does that give you what you want?

Hope this helps.

Pete

[jaryszek]

Hi Pete,

thank you!

I found the way:

Please Login or Register  to view this content.

just use textToColumns - the fast option.

Best,
Jacek