+ Reply to Thread
Results 1 to 6 of 6

Enter the date in A5 and the format will use the ordinal day

  1. #1
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Enter the date in A5 and the format will use the ordinal day

    Enter the date in cell A5 2023/1/21, the cell will immediately change to this result 21st January 2023

    Any help would be greatly appreciated!

    The number of days should be like the picture
    Attached Images Attached Images
    Last edited by rayhen; 05-12-2023 at 04:24 AM.

  2. #2
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Enter the date in A5 and the format will use the ordinal day

    Try this;
    Please Login or Register  to view this content.
    Last edited by Croweater; 05-12-2023 at 02:32 AM.

  3. #3
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,443

    Re: Enter the date in A5 and the format will use the ordinal day

    pls try this code

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    09-01-2020
    Location
    bangladesh
    MS-Off Ver
    office 2007
    Posts
    167

    Re: Enter the date in A5 and the format will use the ordinal day

    WOW @Croweater AND wk9128 Both are awesome thanks for your help problem solved

  5. #5
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Enter the date in A5 and the format will use the ordinal day

    No problems. Thanks for the feedback/rep.

  6. #6
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Australia
    MS-Off Ver
    365 V2403 and WPS V2022
    Posts
    3,443

    Re: Enter the date in A5 and the format will use the ordinal day

    @rayhen You're Welcome. Glad to help . Thank You for the feedback and rep.

+ 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. [SOLVED] VB Code to immediately change the value of cell
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2017, 03:06 PM
  2. apply format cell immediately when pasting data
    By Crazy_Bass in forum Excel General
    Replies: 2
    Last Post: 12-03-2013, 01:18 AM
  3. [SOLVED] VBA to immediately change the colour of a cell depending on the code placed in another cel
    By Phil Payne in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2013, 01:15 PM
  4. instead of editing cell and pressing enter to change format
    By benjamind11 in forum Excel General
    Replies: 1
    Last Post: 01-23-2013, 11:01 AM
  5. Replies: 6
    Last Post: 10-08-2011, 08:16 PM
  6. Replies: 11
    Last Post: 01-19-2010, 06:54 AM
  7. Replies: 4
    Last Post: 08-21-2009, 04:04 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