Share via

Does anyone know what does this date code mean?

Anonymous
2013-09-03T15:34:04+00:00

Hi!

Does anyone know what does the date code [$-C0A] which goes before some custom date formats?

Thanks!!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2013-09-03T15:44:06+00:00

If you select a locale in the dropdown beneath the list of available date codes in the date section and subsequently choose a date format in that locale, then the custom number format shows codes like the one you posted.

A list of those codes can be found here:

http://office.microsoft.com/en-us/excel-help/creating-international-number-formats-HA001034635.aspx

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-09-05T09:12:06+00:00

    That was really awesome. Thank you so much!!

    Was this answer helpful?

    0 comments