+ Reply to Thread
Results 1 to 3 of 3

date format auto changing to decimal

  1. #1
    Registered User
    Join Date
    12-15-2015
    Location
    india
    MS-Off Ver
    2013
    Posts
    28

    date format auto changing to decimal

    hi,
    i need to print title of my report as "pending fee report as on 19-12-2015"
    in this 19-12-2015 is current date that i want to be autoupdated whenever file is opened.
    i have tried following formulae
    1- =CONCATENATE("Pending Fee Report as on",TODAY())
    2- =CONCATENATE("Pending Fee Report as on",NOW())

    But ist returning the result as Pending Fee Report as on42356
    while the reuired output is pending fee report as on 19-12-2015

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,926

    Re: date format auto changing to decimal

    1- =CONCATENATE("Pending Fee Report as on", Text(TODAY(),"dd-mm-yyyy"))

  3. #3
    Registered User
    Join Date
    12-15-2015
    Location
    india
    MS-Off Ver
    2013
    Posts
    28

    Re: date format auto changing to decimal

    thnx dflak......................
    problem solved....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Changing Protected Cell Format to Decimal Places
    By BazzaBoy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2009, 06:54 AM
  2. Excel auto format changing 1-1 into date
    By Laktose_65 in forum Excel General
    Replies: 17
    Last Post: 10-16-2007, 04:57 AM
  3. [SOLVED] Automatically changing stock tick quotes to decimal-price format.
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  4. Automatically changing stock tick quotes to decimal-price format.
    By JE McGimpsey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  5. [SOLVED] Automatically changing stock tick quotes to decimal-price format.
    By Kaci in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. Automatically changing stock tick quotes to decimal-price format.
    By Kaci in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Automatically changing stock tick quotes to decimal-price format.
    By Kaci in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  8. Automatically changing stock tick quotes to decimal-price format.
    By Kaci in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1