account csv download unreadable!

Graham

Stilll struggling with accounts - almost makes me want to quit doing anything!!

however, point is when I download csv and open in exel here is an example of 1 line ::

column A = 9/15/13 0:38
column B = Order Fee
column C = 9808139
column D = -0.29305 (~US $-0.49)

obviously can't work with column D like that!

Thanks!

Graham

hold on what happened, after the $-0.49 there IS this ~ < sp an class='price'>US $-0.49< / sp an >

I added some spaces to see if it will show

column D looks like this -0.29305 (~ < sp an class='price'>US $-0.49 < / sp an >)
all of that symbols and all is in column D

Hoddie

Short-term fix if you need it. Create a column E with the following formula in each row.

=TRIM(LEFT(#,(LEN(#)-13)))

The # should be replaced with column D cell reference (D1 for example) in each row.

This should, in theory at least , remove the (~US $-0.49) and give you a numerical value you can work with.

Hoddie

Sorry didn't see your second post, you'll need to change the -13 to something higher in order to remove all the span, class and other useless stuff. Have a play with it.

Lawrence

Try downloading it again and let me know how you get on.