SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    Show me the money lennymos123's Avatar
    Join Date
    Jan 2002
    Location
    Birmingham, UK
    Posts
    450
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problems with excel full stop removal ?

    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
    Palo Webservices

    No one can make you feel inferior without your consent. Eleanor Roosevelt

  2. #2
    Guru Bullschmidt's Avatar
    Join Date
    Apr 2002
    Location
    USA
    Posts
    524
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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, ".", "")
    J. Paul Schmidt
    www.Bullschmidt.com - Freelance Web and Database Developer
    www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips

  3. #3
    SitePoint Member
    Join Date
    Oct 2003
    Location
    Hampton, UK
    Posts
    13
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

  4. #4
    SitePoint Member
    Join Date
    Apr 2005
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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
    Actinic Support
    Actinic Software Limited


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •