View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Israel Israel is offline
external usenet poster
 
Posts: 47
Default editing a cell with time

Hello all,

I ran into a problem with my spreadsheet, can anybody help?

I have a cell that reads time as follows "01:23p". I'm in desperate need
to edit the cell by adding a space before the letter "p" and add the letter
"m" after the letter "p".

Is there a way to complete this task. I appreciate your response.

Thank you
--
smile