Datafeed problem

[lennymos123]

have just got a datafeed and i'm trying to put it in an actinic
website for a customer. I match every record receipt 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

[Mike Hughes]

remove the '£' sign and multiply by 100 should do it.

Mike