Language on Pivot Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2086231%22%20slang%3D%22en-US%22%3ELanguage%20on%20Pivot%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2086231%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20need%20to%20sent%20my%20client%20an%20pivot%20table%20where%20I%20have%20%3CSTRONG%3Egrupped%20dates%20in%20columns.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EMonth%20name%20is%20in%20my%20language%20-%20how%20can%20I%20force%20format%20to%20English%20%3F%3C%2FP%3E%3CP%3EIn%20normal%20formatting%20I%20use%26nbsp%3B%3CSTRONG%3E%5B%24-en-US%5Dd-mmm-rrrr%3B%40%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2086231%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

I need to sent my client an pivot table where I have grupped dates in columns.

Month name is in my language - how can I force format to English ?

In normal formatting I use [$-en-US]d-mmm-rrrr;@

0 Replies