Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hernan
 
Posts: n/a
Default Print Social Security as formatted.

I have a column formatted as Special/Soc Sec. And it shows the format
correctly. However, it does not print the social security numbers correctly,
that is with the dashes in place?

Any help will be appreciated.

TIA

Hernan
  #2   Report Post  
Posted to microsoft.public.excel.misc
Hernan
 
Posts: n/a
Default Print Social Security as formatted.

Sorry! Wrong Forum. I am trying to mail merge to print labels from Word and
the social security is not properly formatted when the label is printed...

Otherwise, the excel sheet prints ok. :-)

Hernan

"Hernan" wrote:

I have a column formatted as Special/Soc Sec. And it shows the format
correctly. However, it does not print the social security numbers correctly,
that is with the dashes in place?

Any help will be appreciated.

TIA

Hernan

  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Print Social Security as formatted.

Debra Dalgleish posted this to a similar question:

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/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.

Hernan wrote:

Sorry! Wrong Forum. I am trying to mail merge to print labels from Word and
the social security is not properly formatted when the label is printed...

Otherwise, the excel sheet prints ok. :-)

Hernan

"Hernan" wrote:

I have a column formatted as Special/Soc Sec. And it shows the format
correctly. However, it does not print the social security numbers correctly,
that is with the dashes in place?

Any help will be appreciated.

TIA

Hernan


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
Hernan
 
Posts: n/a
Default Print Social Security as formatted.

Thank you Dave for your suggestion. It worked! :-)

"Dave Peterson" wrote:

Debra Dalgleish posted this to a similar question:

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/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://home.earthlink.net/~wordfaqs/...ngWord2002.htm

about half way down the page.

Hernan wrote:

Sorry! Wrong Forum. I am trying to mail merge to print labels from Word and
the social security is not properly formatted when the label is printed...

Otherwise, the excel sheet prints ok. :-)

Hernan

"Hernan" wrote:

I have a column formatted as Special/Soc Sec. And it shows the format
correctly. However, it does not print the social security numbers correctly,
that is with the dashes in place?

Any help will be appreciated.

TIA

Hernan


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
format social security number Kristy Excel Worksheet Functions 2 September 9th 05 04:13 PM
Social Security numbers Hernan New Users to Excel 5 August 11th 05 08:14 PM
Social Security Number format Jean Excel Worksheet Functions 1 March 7th 05 09:37 PM
social security numbers Jean Excel Worksheet Functions 4 March 7th 05 07:37 PM
How can I compare 2 sets of Social Security #'s and Identify dupes vwwolfe Excel Discussion (Misc queries) 1 February 3rd 05 10:08 PM


All times are GMT +1. The time now is 09:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"