View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wayne Wengert Wayne  Wengert is offline
external usenet poster
 
Posts: 16
Default Convert Format of SQL Data

I have an Excel 2003 worksheet that has a data range based on a query
against a SQL Server. A couple of columns returned are the number 1 or 0. I
want to change those cell contents to "True" or "False". How can I
accomplish this? It appears that any formulas in those cells get overlaid by
the external data. I don't see a way to do this in the query?

Any suggestions are most welcome.

Wayne