Patriot301 -
The numbers shouldn't be a problem. You can format them
within the pivot table. Text is another matter. As far
as I know, there is no way to convert text to number
within the pivot table.
Mike
-----Original Message-----
I am trying to programatically create a pivot table with
a tab delimited
data string. The fifth column of this string is the Value
field with
numbers appearing in different formats or even text. I am
creating this
pivot table by dropping the string on a sheet and using
the Jet driver
to populate a record set which in turn populates the
pivot cache. I
need to do it this way since I overshoot the 65000 row
limit for Excel.
I can successfully create the pivot table if I eliminate
all formats
and text values from column 5. I want to know if there is
any way for a
pivot table to handle text based values and number
formats.
Thanks.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/
.