Replace ^ in web query result

Posted to microsoft.public.excel.worksheet.functions

Don Guillett

Posts: n/a

Replace ^ in web query result

I can't remember how to fix this. I am running a web query macro in xl2002.
When I run in xl97 I get a caret ^ at the beginning of each cell.
^$.77

Sorry about multipost but few look at querydao
TIA

--
Don Guillett
SalesAid Software

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Displays the number in text. (One thousand two hundred thirty four	Ashish Patel	Excel Worksheet Functions	1	March 20th 06 09:27 PM
Get External Data - not editable using Query Wizard	MargaretBeckbury	Excel Discussion (Misc queries)	7	January 17th 06 09:13 AM
How can i change this VBA project According to Indian Numeric	Rao Ratan Singh	Excel Discussion (Misc queries)	1	April 21st 05 07:53 PM
Is there a formula to spell out a number in excel?	Sha-nay-nay	Excel Worksheet Functions	2	December 18th 04 09:25 PM
Convert Numeric into Text	Monty	Excel Worksheet Functions	0	December 18th 04 09:25 PM

All times are GMT +1. The time now is 10:38 AM.

Menu

About Us