+ Reply to Thread
Results 1 to 2 of 2

prices do not load properly into the pricelist for our website

  1. #1
    Registered User
    Join Date
    02-06-2008
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    71

    prices do not load properly into the pricelist for our website

    when i use concatenate to create prices for our website the price often comes in like $5.5 or $5.595 instead of $5.50.

    i have used all the different types of files - text, general, numbers, all the other types.

    i have tried using roundup.

    nothing works for me. Cactus Shop mar11 test.xlsx

  2. #2
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: prices do not load properly into the pricelist for our website

    You could try this in cell I2 and fill down and see if it works:

    =CONCATENATE(TEXT(E2,"$0.00")," (minimum ",G2,")")

    - Moo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1