Excel time formats to text...

[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......

 

[Frank Kabel]

Hi
use the following formula in your target cell
=TEXT(A1,"hh:mm")

 

[Road Rally]

Fab! Thanks Frank :