Re: Format Time to NOT show seconds and AM/PM

Giganews Newsgroups
Subject: Re: Format Time to NOT show seconds and AM/PM
Posted by:  Diana
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
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx
>
> And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
> has instructions here:
>
http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm
>
> about half way down the page.
>
> ==========
> I often cheat instead of racking my brain.
>
> I'll insert another column (probably hidden!) and use:
> =text(a2,"ddmmyy")
> or
> =text(a2,"mm:ss.0")
> or
> =text(a2,"00000")
> (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

Replies

None

In response to

Re: Format Time to NOT show seconds and AM/PM posted by Dave Peterson on Thu, 31 Jul 2008