We are downloading data from the mainframe and opening in Excel. The Text to column wizard is utilized, data is fixed length. The heading row contains data like
42-3 45-2 3-1
The first two work fine. However 3-1 is interpreted as a date.
Can I avoid this? The rows below contain numeric values, so loading columns as text is not an option.