pivot tables

%3CLINGO-SUB%20id%3D%22lingo-sub-3111012%22%20slang%3D%22en-US%22%3Epivot%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111012%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%3C%2FP%3E%3CP%3Ei%20am%20looking%20to%20format%20the%20output%20from%20a%20pivot%20when%20it%20creates%20a%20new%20tab%20in%20the%20worksheet.%3C%2FP%3E%3CP%3ESo%20i%20double%20click%20in%20the%20pivot%20to%20create%20the%20data%20i%20want%20but%20I%20cant%20preset%20the%20format%20of%20the%20new%20sheet.%20I%20want%20it%20to%20be%20a%20certain%20number%20format%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3111012%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

hi

i am looking to format the output from a pivot when it creates a new tab in the worksheet.

So i double click in the pivot to create the data i want but I cant preset the format of the new sheet. I want it to be a certain number format ?

 

0 Replies