+ Reply to Thread
Results 1 to 5 of 5

Vlookup problems with decimal

  1. 05-13-2020, 01:07 PM #1
    fabian_76
    fabian_76 is offline
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    279

    Vlookup problems with decimal

    Hi I have the below code which brings prices such as $2329.63 however after doing the vlookup it rounds my number to 2330.00.

    Any help to imported the number as it appears in my source data?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 05-13-2020, 01:21 PM #2
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Vlookup problems with decimal

    Yes of course result is long, change it to Single
    BTW you should disable event as you are changing cell value to record result
    - Battle without fear gives no glory - Just try
    Reply With QuoteRegister To Reply
  3. 05-13-2020, 01:26 PM #3
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Vlookup problems with decimal

    See next code
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 05-13-2020, 02:04 PM #4
    fabian_76
    fabian_76 is offline
    Forum Contributor
    Join Date
    03-14-2015
    Location
    Mexico
    MS-Off Ver
    365
    Posts
    279

    Re: Vlookup problems with decimal

    Great. Thanks for the help, it worked.
    Reply With QuoteRegister To Reply
  5. 05-13-2020, 02:15 PM #5
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Vlookup problems with decimal

    Super, Thx for the Rep. ...!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problems converting fraction as a text cell to a decimal
    By KTENHAKEN in forum Excel General
    Replies: 4
    Last Post: 12-09-2019, 01:38 PM
  2. [SOLVED] Experiencing Problems with Numbers breaking down to random decimal places
    By Daniel_McCann in forum Excel General
    Replies: 7
    Last Post: 10-13-2014, 11:00 AM
  3. Time to Decimal problems!
    By 99jamhar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-04-2013, 01:24 PM
  4. Still having problems with converting h:m to decimal
    By andyb_work in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-08-2008, 04:01 PM
  5. VLOOKUP and decimal places
    By Lionne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-23-2007, 01:58 PM
  6. Converting to .csv - problems with decimal point truncation
    By bluepenguin in forum Excel General
    Replies: 1
    Last Post: 11-19-2007, 10:36 PM
  7. Localisation decimal problems
    By Mats Samson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2006, 11:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1