Hold format from excel to data source for mail merging

F

Frank3

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

Bernie Deitrick

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
 
F

Frank3

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...
 
Top