Hold format from excel to data source for mail merging
 

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


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

Thanks, I'll try it.

"Bernie Deitrick" wrote:

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


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