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!
|