Cross Table to List Error with Numbers as Text

[FatLittleDog]

First of all the Cross Table to List function is GREAT!  And saved me TONS of time!  and I purchased my license right away because of the obvious value.

BUT one of the very important uses I have for this function is working with an Excel table that has numbers as labels for the first column (eg. the cell contains '007133060149).  When I perform the cross table to list function, the values in the CrossTab Column Headers column convert to actual number values (eg. 7133060149).

What should I be doing to preserve the numbers as text and not convert to actual values?

Thanks again for the great and VERY USEFUL function!

FatLittleDog

[DigDB Support]

Sorry for the delay in getting back to you.

Can you append some random texts, for example, append "FDFDDF" to each cell in the source data (for append, see http://www.digdb.com/excel_add_ins/append_column_before_after/), then do the operation. After the operation, use Excel's Replace to replace "FDFDDF" by ' (tick). This will keep the 0013213 format.

[FatLittleDog]

Thank you - I'll try that!