Results 1 to 7 of 7

function displaying the right values of dates and moneyamounts

Threaded View

  1. 08-23-2022, 05:07 AM #1
    MaartenRo
    MaartenRo is offline
    Forum Contributor
    Join Date
    02-27-2020
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    447

    function displaying the right values of dates and moneyamounts

    Hi,

    I have a sheet with names, dates and money amounts in columns A,B and C. I have them all displayed together in column D with the function:
    = [@name]& " | " &[@Date] & " | " & [@Moneyamount].

    The problem is that "William | 44731 | 100" is displayed instead of "William | 19-6-2022 | ?100"
    How can i let the function display the right values?
    Attached Files Attached Files
    Last edited by MaartenRo; 08-26-2022 at 06:51 AM.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Displaying Different Values Assigned to 'Column' Argument using the Offset Function
    By Lion_roar in forum Excel General
    Replies: 20
    Last Post: 07-30-2021, 02:10 PM
  2. Displaying values and function on a number of cells based on a list
    By sullivanstarship in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-29-2016, 05:03 PM
  3. Displaying subset of dates from a range of dates
    By DDE12 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 10-06-2015, 06:30 PM
  4. VBA Find Function and Displaying the other Column's Values
    By nori79 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-15-2015, 12:23 PM
  5. Trying to gets displaying as dates when returned by formula (not displaying as 41000, etc)
    By Motox in forum Excel General
    Replies: 2
    Last Post: 02-05-2013, 04:52 AM
  6. Displaying Multiple Values without using Macros or ROWS function
    By ltzhao in forum Excel General
    Replies: 7
    Last Post: 03-16-2009, 09:17 AM
  7. Displaying Multiple Values without using Macros or ROWS function
    By ltzhao in forum Excel General
    Replies: 1
    Last Post: 03-13-2009, 11:03 PM

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