Keep formatting in pivot table

[murphyz]

I have a two sheets, one with data and one acting as a search page that refreshes a pivot table to match searchwords found in data.

Is it possible to format the data in the first spreadsheet, and have the pivot table keep that formatting?

Also, is there a size restriction on the amount of data shown in the pivot table? I noticed whilst putting a lengthy bit of information into a cell, the pivot table seemed to cut it off.

Many thanks

Mxx