Hold format from excel to data source for mail merging

Frank3

Posts: n/a

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel changing number formatting and source data in graphs on it's own!!!	JohnHamer	Excel Discussion (Misc queries)	2	September 22nd 05 02:29 PM
Help PLEASE! Not sure what answer is: Match? Index? Other?	baz	Excel Worksheet Functions	7	September 3rd 05 03:47 PM
How can deleted data reappear in a refreshed pivot table in Excel	excel_user123456	Excel Discussion (Misc queries)	3	February 23rd 05 08:34 PM
Fetching External Data from Excel	Sri	Excel Discussion (Misc queries)	2	January 3rd 05 11:46 AM
Excel 97 chart opened in Excel 2003 - Source Data problem	DHunt	Charts and Charting in Excel	0	December 6th 04 08:05 PM

All times are GMT +1. The time now is 07:23 AM.

Menu

About Us