I work a lot with pivot tables and wondered if you can import text or special
formating into the table. Whenever I try to do this, the column shows up as
"0" and I have tried formatting about every way. For example if I want to
import a date, text, or something such as DK537RR, it shows up as zero and
not what I want. Can anyone help me.