|Subject:||Re: Format Time to NOT show seconds and AM/PM|
|Date:||Thu, 31 Jul 2008|
Thanks to much!!
"Dave Peterson" wrote:
> 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>.)
> Diana wrote:
> > 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?
> Dave Peterson
Re: Format Time to NOT show seconds and AM/PM posted by Dave Peterson on Thu, 31 Jul 2008