CODEWITHSUNDEEP
excel
mgae2m
mgae2m

Reputation: 1142

Inconsistency of date format in MS-Excel between formula and cell

I defined Custom formatcategory in Format cells as yyyy/mm/dd for a column of cells.

When in entering a date in this cells, its shown truly in this cell, but shown as dd/mm/yyyy in Formula bar, and when entering in a appropriate application, encountering error in date!

Upvotes: 0

Views: 320

Answers (1)

G42
G42

Reputation: 10019

The date formatting in the Formula bar is not determined by the custom formatting. It is determined by the Short date formatting in the Region or Region and Language settings (depending on OS version)

Region settings

Upvotes: 1

Related Questions