![Old](images/statusicon/post_old.gif)
8th April 2010, 09:24 PM
|
Member
|
|
Join Date: Jan 1970
Location: Western Australia
Posts: 3,455
|
|
Excel Problem
Hi, i posted this question on an excel site but can't get any help maybe a punter with good excel knowledge could help.
I am trying to import some data from a bookie site problem is part of the data is formatted to a point i can't use it, how can i get it to a usable format
here is a link to the site
http://www.sportingbet.com.au/uipub/...ventType=races
I can just import the table i want but if you import the whole page the section i need to work columns AG and AK now AK has some separation i can work with np but AG changes the number format and i can't get it back to the original numbers.
__________________
One Drive
"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________
|