R
Road Rally
Does anyone know how to change a cell with a time format into text i
excel, and get the cell to display the actual time, rather than th
'exel numerical format' of the time......i.e.
If I put 12:20 into a cell with a time format, and copy/paste it into
blank cell with a text format, it displays 0.513889 instead of 12:20..
I need to save the file as a .txt file to import the data into anothe
software package...... at the moment, even though excel displays th
time as 12:20, it saves in the numerical format
I've a file with 14,000 times on it, so re-entering the data isn'
really an option.....
Thanks. Anyone......
excel, and get the cell to display the actual time, rather than th
'exel numerical format' of the time......i.e.
If I put 12:20 into a cell with a time format, and copy/paste it into
blank cell with a text format, it displays 0.513889 instead of 12:20..
I need to save the file as a .txt file to import the data into anothe
software package...... at the moment, even though excel displays th
time as 12:20, it saves in the numerical format
I've a file with 14,000 times on it, so re-entering the data isn'
really an option.....
Thanks. Anyone......