+ Reply to Thread
Results 1 to 3 of 3

Link cell from one sheet to another, but it's dropping the ending zeroes

  1. #1
    Registered User
    Join Date
    02-03-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2013
    Posts
    22

    Link cell from one sheet to another, but it's dropping the ending zeroes

    I have a dollar amount in B4 ($1.50) and B5 ($0.40).

    I want it to automatically populate another sheet, but it's dropping the zeroes.

    I want the ending text to say:

    "Student Lunch $1.50 Reduced Price $0.40"

    But it's saying:

    "Student Lunch $1.5 Reduced Price $0.4"

    My formula is: ="Student Lunch $"&Home!B4&" Reduced Price $"&Home!B5

    Can you please help me fix it? Thank you!

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Link cell from one sheet to another, but it's dropping the ending zeroes

    hi gawk1980, try:
    ="Student Lunch "&DOLLAR(Home!B4)&" Reduced Price "&DOLLAR(Home!B5)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    02-03-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2013
    Posts
    22

    Re: Link cell from one sheet to another, but it's dropping the ending zeroes

    Thank you so much! You all are so helpful!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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