Forum Discussion
Converting a 4 digit number to time
I have just changed to 365 from an older version of Excel. I have a large amount of data that I import from CSV, which has times recorded as 4 digit numbers. I need to display it as a time (ie 1330 t...
MAngosto Thank you, that worked on the data, but it all goes sideways, if I try to copy and paste it somewhere else and my screen fills up with #ref
Any formula could give such effect. To avoid it paste as values.
Alternatively you may Ctrl+1 on the cell(s) and apply custom format
With that simple paste, not paste as value.
Assuming you perform no calculations with such values.