Converting a time format to a String format in Excel

B

Bill Partridge

Hi,

Can somebody advise me if it is possible to convert a time formated cell to
a string in Excel?
 
B

Bill Partridge

Thanks,

Another question then. I have 2000 entries in the spreadsheet, is there a
function that allows me to insert an apostrophe on mass into either the
existing column or a new calculated column i.e. column f1 = ' +c1?
 
Top