Results 1 to 3 of 3
  1. #1
    Join Date
    August 11th, 2006
    Why are fields with numbers suddenly adding decimal places?
    Why has one of my fields (formatted as a number) suddenly adding decimal points? That is, a number that appears as "10" now appears as "10.00." It's screwing up my merges, naturally. Any idea how to remedy this? (the data's being pulled from an access db.)

  2. #2
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    I don't think Webmerge does anything that can manipulate the data like that. It sounds like your source file has that column setup to use decimals. You may want to open it up and try changing it to a non-decimal format and see if that fixes the problem.
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  3. #3
    Join Date
    August 11th, 2006
    Thanks for the word. I had started to come to the same conclusion - and found (by checking my txt file exports) that some numbers were appearing (exporting) with the two decimal places. I'm not sure why unless it was access' "auto" decimal setting within the individual field's properties setting. I set the guilty parties to "0."

    Thanks again.
    Last edited by tvsmvp; November 1st, 2006 at 04:42 PM. Reason: typo

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Discrepancy: Google Numbers vs. ShareASale Numbers
    By shocker in forum ShareASale - SAS
    Replies: 1
    Last Post: April 24th, 2011, 05:58 PM
  2. Price Angels and Decimal Points
    By iCodes in forum ShareASale - SAS
    Replies: 1
    Last Post: February 16th, 2011, 05:58 PM
  3. Suddenly No Sales?
    By nimblefingers in forum ShareASale - SAS
    Replies: 6
    Last Post: December 12th, 2008, 03:18 PM
  4. Replies: 1
    Last Post: February 9th, 2005, 11:49 AM

Posting Permissions

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