Hold format from excel to data source for mail merging

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There has to be a way to hold the numbering format in excel spreadsheet when
it converts to data source for mail merging. Help!
 
Frank,

Try running this macro on a copy of your spreadsheet.

Sub Convert()
Dim myCell As Range
For Each myCell In ActiveSheet.UsedRange
myCell.Value = "'" & myCell.Text
Next myCell
End Sub

HTH,
Bernie
MS Excel MVP
 
Thanks, I'll try it.

Bernie Deitrick said:
Frank,

Try running this macro on a copy of your spreadsheet.

Sub Convert()
Dim myCell As Range
For Each myCell In ActiveSheet.UsedRange
myCell.Value = "'" & myCell.Text
Next myCell
End Sub

HTH,
Bernie
MS Excel MVP
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Best solution to merge multiple Outlook contacts easily 2
How to subtract a number from a Mergefield? 0
Merge Problems 1
Import data from Word 1
How do I maintain cell formatting when I export to a mail merge? 2
Display date in spanish 3
Using Excel for mail merge 2
Help with large texts in excel spreadsheets 1

Back
Top