|Subject:||Re: Format Time to NOT show seconds and AM/PM|
|Posted by:||Dave Peterson (peters…@verizonXSPAM.net)|
|Date:||Thu, 31 Jul 2008|
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you:
Answer Box: Numbers don't merge right in Word
And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:
about half way down the page.
I often cheat instead of racking my brain.
I'll insert another column (probably hidden!) and use:
(or whatever format I want)
and use that field in the mailmerge.
(Cheating doesn't bother me anymore <vbg>.)
> I am bringing data with appointment Times over from another program. I am
> using a TIME formula to subtract 15 minutes off to let person know when to
> show for appointment.
> Problem that is occurring is how the time shows. The time in the cell
> itself shows as 1:30 but when you click on the cell & view it in the formula
> bar, it shows as 1:30:00 AM. I'm Mail Merging (WORD) this data for letters
> and do NOT want the full time with seconds and AM/PM to show on the letter.
> How do I format this in EXCEL so only the 1:30 shows?
Format Time to NOT show seconds and AM/PM posted by Diana on Thu, 31 Jul 2008