- #1
nomadreid
Gold Member
- 1,672
- 206
- TL;DR Summary
- I want my dates to appear in the format dd/mm/yyyy, so I set the cell to Category: Date, Type: English (United Kingdom). I type in 3/4/2019 (3 April 2019), and Excel converts it to 04/03/2019. What is going on?
The summary is complete to describe the problem, but to forestall the solution to either (a) leave the Category : "number" and just type what I want, or (b) put the Type as "English(United States)" and type 3/4/2019, I mention why these solutions would create difficulties: a person to whom I will send the spreadsheet will then link the cells to another spread sheet in order to determine data for that day, and an ambiguity would cause problems.