The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Client Support
cancel
Showing results for 
Search instead for 
Did you mean: 

Send to Print Merge - Some Record Numbers Appear in Date Format

SOLVED
Go to solution
Highlighted
Adam_Ledwos
Regular Collector

Send to Print Merge - Some Record Numbers Appear in Date Format

Hi Folks,

 

When attempting Send to Print Merge (Tab Delimited) a list of Records, when I open in Excel, some of the Record Numbers appear in Date Format. Despite my attempts to reformat cells back to a Record Number, I am unable to. Example Attached

 

Any ideas why this is happening.

 

TRIM 6.24 (1240)

 

Thanks

 

 

Adam
3 REPLIES
TRIMGuru
Honored Contributor
Solution

Re: Send to Print Merge - Some Record Numbers Appear in Date Format

When you open it up into excel, in the wizard that opens for a text file, when you get to Step 3 of 3, select ALL columns, then click on TEXT (vs the default of GENERAL).  That will bring everything in as text and you shouldn't have a problem with the record number field then.

 

TIP:  This method will also ensure that any leading zero's are not dropped off.

 

Adam_Ledwos
Regular Collector

Re: Send to Print Merge - Some Record Numbers Appear in Date Format

Indeedy - You are the Guru!

 

Thanks for your assistance.

Adam
TRIMGuru
Honored Contributor

Re: Send to Print Merge - Some Record Numbers Appear in Date Format

You're most welcome, glad it worked for you   :smileyhappy:

//Add this to "OnDomLoad" event