In cell A:1 I have 15/05/1974 which is formatted as 19740515

I want to see 19740515 in the edit line as I need to create a csv with
19740515 and not 27164

Any ideas?