Alpha Video Training
Results 1 to 3 of 3

Thread: Can somebody help me out

  1. #1
    Member
    Real Name
    Dave Kenney
    Join Date
    Aug 2007
    Posts
    9

    Default Can somebody help me out

    I have a import operation that is importing a numeric field with the decimal in the wrong place. the number is imported as 590064.00 when it should be 5900.64, I am using version 12 with all the latest patches, is there a function that I can use to fix this?

  2. #2
    Member
    Real Name
    Jeremy Scrime
    Join Date
    Sep 2015
    Posts
    76

    Default Re: Can somebody help me out

    Divide by 100, 590064.00/100 = 5900.64

  3. #3
    Member
    Real Name
    Dave Kenney
    Join Date
    Aug 2007
    Posts
    9

    Default Re: Can somebody help me out

    Yup that did it....I should have known that but I guess I had a brain skip, thank you

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
  •