Problem with formatting , need to get rid of decimal point .....

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

I 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
 
Hi Paul

one idea that you might like to do on a copy of the data (just in case) is
to type 100 into a cell somewhere and copy it, then select all of the
numbers you want to remove the decimal from and choose edit/ paste special -
multiply ... your numbers now should be as you want them.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
I 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
 
Back
Top