CODEWITHSUNDEEP
excel
Steven Martin
Steven Martin

Reputation: 3290

Excel Custom Format meaning

What is this custom formatting actually doing if anything? Why is [$-11809] there?

[$-11809]dd/mm/yyyy

Raw Value           42521.5565907755 
In Formula Bar      31/05/2016  13:21:29 
Custom Format       [$-11809]dd/mm/yyyy
Display in Cell     31/05/2016

Upvotes: 1

Views: 83

Answers (1)

Robin Mackenzie
Robin Mackenzie

Reputation: 19289

It represents a locale ID - here's a list from MSDN. But it seems like there is is maybe a typo. The decimal format for Lao is 1108 and the hexdecimal format for Ireland is 1809 - but nothing for 11809.

See this post as well.

Upvotes: 4

Related Questions