"Wayne Wengert" wrote in message
...
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


Let's say your data goes to columns A to F and you get number 1 or 0 in
columns A and C
Copy the data to columnns D-F by enterering, this
D1: = IF(A1=1,"True","False")
E1: =C1
F1: = IF(C1=1,"True","False")
Drag these formulas downwards and hide columns A-C

/Fredrik