Results 1 to 7 of 7

Change From 1 January 2015 Thursday to 1 January 2015 Thu

Threaded View

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,014

    Change From 1 January 2015 Thursday to 1 January 2015 Thu

    Greetings,
    1- I have entered 1.1.2015 into A1 cell.
    2- I am looking at A1 cell and see 1.1.2015.
    3- Right click A1 cell >> edit cells >> date >> 1 January 2015 Thursday
    4- I am looking at A1 cell and see 1 January 2015 Thursday

    I want to see 1 January 2015 Thu instead of 1 January 2015 Thursday in the A1 cell.
    So, I want to see first three letter of the day name.
    I need a vba code for this.

    Thank you very much.
    Last edited by HerryMarkowitz; 07-14-2015 at 10:46 AM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Call in the Cavalry - 2015
    By davesexcel in forum The Water Cooler
    Replies: 297
    Last Post: 01-13-2016, 06:50 PM
  2. New User 06/30/2015 -
    By ehdz0222 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-30-2015, 10:50 AM
  3. 2015 election results
    By Quadhurst in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-24-2015, 03:48 PM
  4. RWC 2015 Predicter
    By Hardbody in forum Excel General
    Replies: 1
    Last Post: 05-20-2015, 05:24 AM
  5. Error 2015 and #VALUE!
    By vop2311 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2014, 01:46 AM
  6. [SOLVED] Error 2015
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-25-2006, 03:40 PM
  7. N/A # and error 2015
    By ina in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-27-2006, 05:55 AM

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