Trying to change the ddmmyyyy date to yymmdd or yyyymmdd in a stock prices, Date OHLC txt file.
I tried Data/TexttoColumns/etc which didn't change anything.
WHY don't spreadsheet programs provide yyyy in Format/Cells/Number/Date ???
Besides this small matter driving me crazy, any instructions should be very simple please because I'm not often an Excel user . . .
TIA
I tried Data/TexttoColumns/etc which didn't change anything.
WHY don't spreadsheet programs provide yyyy in Format/Cells/Number/Date ???
Besides this small matter driving me crazy, any instructions should be very simple please because I'm not often an Excel user . . .
TIA