+ Reply to Thread
Results 1 to 19 of 19

date into text while keeping the date in its initial format

Hybrid View

  1. #1
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2503 Build 16.0.18604.20000) 64-bit
    Posts
    3,999

    Re: date into text while keeping the date in its initial format

    It will be better if you can upload the spreadsheet for uploading Go to Advance and click on attachment link.

    What is VBA?
    Ans->Excel VBA (Visual Basic for Applications) is the name of the programming language of Excel. 1 Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  2. #2
    Registered User
    Join Date
    01-13-2016
    Location
    kigali
    MS-Off Ver
    2003
    Posts
    27

    Re: date into text while keeping the date in its initial format

    I don't see advance, can you indicate it for me please?

  3. #3
    Registered User
    Join Date
    01-13-2016
    Location
    kigali
    MS-Off Ver
    2003
    Posts
    27

    Re: date into text while keeping the date in its initial format

    i have uploaded an excel document. there are a number of months I want to use the formula you have given me on few months and then scroll down to other months
    thank you
    Attached Files Attached Files

+ 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. Combining cells, keeping date format.
    By emccalment in forum Excel General
    Replies: 2
    Last Post: 02-26-2016, 11:12 AM
  2. Data Analysis: Compare initial date with final date by looking up the latest revision
    By White_Glint in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2015, 02:31 PM
  3. [SOLVED] Data Validation: using date in as initial date in range
    By dmorl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-01-2015, 10:10 AM
  4. Concatenate text, date and time keeping format
    By TiagoG in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2015, 07:07 PM
  5. Keeping Date Format in String
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-05-2012, 12:39 PM
  6. Replies: 1
    Last Post: 06-06-2011, 10:08 AM
  7. Convert cell category from Date to Text, keeping mm/dd/yyyy format
    By chachie22 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-07-2011, 05:00 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