Problems with excel full stop removal ?

[lennymos123]

I have just got a datafeed and i'm trying to put it in an actinic website for a customer. I match every record eccept price feed Actinic says imported fields must not contain any decimal points i.e £1000.00 should be 100000 how do i do this in excel ? I can't see anyway of formatting it to match the requirements

Paul

[Bullschmidt]

Since no one else has answered I'll just throw in a stab in the dark.

Perhaps you could multiply it by 100 somehow.

Or of couse with pure ASP you could do:

MyVar = Replace(MyVar, ".", "")

[brucet]

I've emailed one of our technical guys to ask if he can help you.

You could also try posting this question on the Actinic Community, http://community.actinic.com

Best regards

Bruce Townsend
Actinic Software

[nrasool]

Hi there

What "Bullschmidt" had written is correct. You would need to create a new column on your excel spreadsheet and simply use the the formula (<price> * 100). Then Actinic will accept the excel file.

Kind Regards

Nadeem Rasool