<div>
Question was not correct, I stated the ultimate resolution and awarded points for troubleshooting assistance.
</div>


<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
Question: &nbsp;How to I insure that all cells in a data connection refresh as straight text? <br />
<br />
I have an Excel 2010 workbook with three tabs that map to SQL Server views. &nbsp;<br />
All columns are varchar's, but some values are in the correct format for currency (e.g. $0.00) <br />
<br />
When I Data .. Refresh All, the varchar's with currency numbers are showing with a trailing space, even though when I right-click:Properties the format in the Number tab is General. <br />
<br />
I tried creating VBA code in the Workbook_Open event to select all three tabs and do a Selection.ClearFormats, but that isn't working. <br />
<br />
Thanks in advance.<br />
Jim
</div>
</div>


Hi All

Question:  How to I insure that all cells in a data connection refresh as straight text? 

I have an Excel 2010 workbook with three tabs that map to SQL Server views.  
All columns are varchar's, but some values are in the correct format for currency (e.g. $0.00) 

When I Data .. Refresh All, the varchar's with currency numbers are showing with a trailing space, even though when I right-click:Properties the format in the Number tab is General. 

I tried creating VBA code in the Workbook_Open event to select all three tabs and do a Selection.ClearFormats, but that isn't working. 

Thanks in advance.
Jim

Question was not correct, I stated the ultimate resolution and awarded points for troubleshooting assistance.

Excel 2010 Data Connections, Need to make sure all cells are text

Hi All

Question:  How to I insure that all cells in a data connection refresh as straight text? 

I have an Excel 2010 workbook with three tabs that map to SQL Server views.  
All columns are varchar&#39;s, but some values are in the correct format for currency (e.g. $0.00) 

When I Data .. Refresh All, the varchar&#39;s with currency numbers are showing with a trailing space, even though when I right-click:Properties the format in the Number tab is General. 

I tried creating VBA code in the Workbook_Open event to select all three tabs and do a Selection.ClearFormats, but that isn&#39;t working. 

Thanks in advance.
Jim

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.