EXCEL COURSE PART ONE - FORMATTING A DATABASE

General format is OK for all your fields except DATE. You will need to change the date format. In the Column Data Format box at top right the “Date” option should have the default value . DMY . against it. This means that Excel is expecting that any Date fields it finds in the text file will be in Day/Month/ Year format, which is the UK ... ................
................