formatting time

  • Thread starter Thread starter Hillary
  • Start date Start date
H

Hillary

How do I take off the seconds in my time-formatted cells?
They look ok in the worksheet (h:mm) but in the formula
bar and when I merge the data into WORD, the seconds show
up. I also created a Custom format and that didn't work.
 
Hillary
You can't remove the seconds from the formula bar. Formatting only changes the display of the cell, while the formula bar shows the actual number

I tried a Mail Merge in word and it seemed to bring in the format that was set in my Excel file. Maybe this site might help

http://word.mvps.org/FAQs/MailMerge

Regards
Mark Graesse
(e-mail address removed)


----- Hillary wrote: ----

How do I take off the seconds in my time-formatted cells?
They look ok in the worksheet (h:mm) but in the formula
bar and when I merge the data into WORD, the seconds show
up. I also created a Custom format and that didn't work
 
Back
Top