I hold a pivot table near a bunch of number field. When I tag on a grazing land to the table from the pasture detail, it default to broad number format. I know how to set the number format for a pasture and set it to preserve formatting on re-acquaint yourself with. All of the how-to's I've read on the preserve formatting issue seem to be to assume that the field will remain in the table. However, I don't want to other show adjectives twenty field, so I'm constantly dragging them into and out of the table and this forces me to constantly reformat.
It seem that you should know how to set a defaulting format for a area that would keep at it regardless of whetehr the enclosed space be anyone view within the table.
A solution to this would engender my month!
Answers: That would be a correct phase, unluckily, I don't believe it can be done. The closest you could seize, that I can devise of, is to format the underlying cell instead of the column, so that if it is other alike type of background you are dragging in, you can be sure it will be formatted equal since the formatting be applied directly to the cell instead of the column.