MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

International Date(formatting)

  Asked By: Archie    Date: Dec 22    Category: MS Office    Views: 1671

When doing the Format(Date, "Long Date")

It works alright for USA, Italian, Norwegian dates when changing the Regional
However, it doesn't work for United Kingdom(English) International date.
It formats it as a serial #, much like the date serial# when written to a cell.
Why so ?



3 Answers Found

Answer #1    Answered By: Adalwine Fischer     Answered On: Dec 22

Generally this depends on the settings in control panel/regional settings.
Have a look there on the particular UK computer and see what is entered for
long date.

Answer #2    Answered By: Kristin Johnston     Answered On: Dec 22

You are right when changing  the Regional Settings to UK and see what it is.
However, when executing Format(Date, "Long Date") and place the resulting value
into a cell,
doesn't yield the proper result---it results in a date  serial# within the cell.
Try it and see.

Answer #3    Answered By: Beatriz Silva     Answered On: Dec 22

All sorts of weird stuff happening. Seems to depend on options in control
panel *and* in the cell  format setting in Excel. Unfortunately I haven't
come up with a reasonable explanation and don't have time to investigate

Didn't find what you were looking for? Find more on International Date(formatting) Or get search suggestion and latest updates.