Announcement

Collapse
No announcement yet.

INSERT DATE in Special FORMAT via MACRO

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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,

    Comment


    • #3
      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?

      Comment

      Working...
      X