How do I format a social security filed?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hernan - 27 May 2005 21:58 GMT

I have a field that I liked to have to output a social security number with
its dashes, and also 2 other fields in which the first holds today's date and
the other should be a week later from today's date. How can I accomplish that?

Thanks in advance.

Hernan

Reply to this Message

Graham Mayor - 28 May 2005 05:48 GMT

If you let us know the format of social security numbers in your country
(contributors here are from all over the world) then we could advise, but
http://www.gmayor.com/formatting_word_fields.htm should give you a few
clues.

Date calculations are tricker - see
www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a field that I liked to have to output a social security
> number with its dashes, and also 2 other fields in which the first
[quoted text clipped - 4 lines]
>
> Hernan

Reply to this Message

Doug Robbins - 28 May 2005 08:19 GMT

Running a macro containing the following code will insert a date 30 days in
the future at the location of the cursor.

Selection.InsertBefore DateAdd("d", 7, Date)

You can use the formatting function to get the format that you want. e.g.

Selection.InsertBefore Format(DateAdd("d", 7, Date), "dddd, MMMM d, yyyy")

will insert

Saturday, June 4, 2005

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have a field that I liked to have to output a social security number with
> its dashes, and also 2 other fields in which the first holds today's date
[quoted text clipped - 5 lines]
>
> Hernan

Reply to this Message