Results 1 to 10 of 10

Number Format from Round Function within Concatenate

Threaded View

zeze Number Format from Round... 12-02-2011, 07:13 PM
tigeravatar Re: Number Format from Round... 12-02-2011, 07:17 PM
allwinaugustine Re: Number Format from Round... 07-23-2020, 03:41 AM
zeze Re: Number Format from Round... 12-05-2011, 05:07 PM
daddylonglegs Re: Number Format from Round... 12-05-2011, 05:11 PM
NBVC Re: Number Format from Round... 12-05-2011, 05:21 PM
daddylonglegs Re: Number Format from Round... 12-05-2011, 05:25 PM
Haris Zahid Re: Number Format from Round... 12-24-2017, 06:50 PM
joeu2004 Re: Number Format from Round... 12-24-2017, 08:02 PM
protonLeah Re: Number Format from Round... 12-24-2017, 09:22 PM
  1. #1
    Registered User
    Join Date
    12-02-2011
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Number Format from Round Function within Concatenate

    I'm using a round function within a concatenate function. I am rounding to 2 decimal places, but if the result has trailing zeroes, the round function will delete them. I'd like for it to always display two decimal places.

    For example, if I have numbers 2.999 and 4.354 and I want a cell that displays "3.00-4.35" so I use the formula
    =concatenate(round(2.999,2),"-",round(4.354,2))
    But this displays "3-4.35" instead.

    I can't use the "Format Cells" option, because the cell is no longer in number format. Trying a "custom" format like "#.##-#.##" does not work. I also tried the "Set Precision as Displayed" option, but it did nothing.

    Is there any way I can force Excel to display the trailing zeroes when my numbers are calculated by functions?

    Thanks!
    Last edited by zeze; 12-05-2011 at 05:08 PM.

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