Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: INSERT DATE in Special FORMAT via MACRO

  1. #1
    Join Date
    14th November 2011
    Posts
    28

    INSERT DATE in Special FORMAT via MACRO

    Hi,

    I am looking for a Macro which insert date in cell A1 in sheet in the follwing format.

    ##DATA[20111201]

    FORMAT
    ##DATA[YearMonthDate]

    If any body can help me for this format via macro codes.

    With best regards,
    Masson

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th November 2011
    Posts
    28

    Re: INSERT DATE in Special FORMAT via MACRO

    Hi,

    Is anyone found the solution?

    It will be ok if I find How can I insert date in this format?

    [20111201]

    best,

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    14th November 2011
    Posts
    28

    Re: INSERT DATE in Special FORMAT via MACRO

    Hi I can insert date in this 2011 12 01 format with Swedish or chinees date format.
    But 20111201 I want to now remove the space in the date.

    or

    This format also know as "iso 8601 date format" anyone provide me VB Macro for "iso 8601 date format"

    Any Idea?

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 6
    Last Post: February 24th, 2011, 04:27
  2. Date Format Lost With Paste Special-Values
    By Timbo in forum EXCEL HELP
    Replies: 4
    Last Post: October 19th, 2006, 18:51
  3. Insert Comment & Format Macro
    By zapacoman in forum EXCEL HELP
    Replies: 2
    Last Post: June 3rd, 2006, 02:23
  4. macro to paste special value or format
    By kenshin in forum EXCEL HELP
    Replies: 2
    Last Post: September 16th, 2005, 08:29
  5. Replies: 2
    Last Post: May 19th, 2005, 23:31

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
  •  
porno