customize date for header

%3CLINGO-SUB%20id%3D%22lingo-sub-1509264%22%20slang%3D%22en-US%22%3Ecustomize%20date%20for%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509264%22%20slang%3D%22en-US%22%3E%3CP%3Ei.%20have%20been%20trying%20to%20customize%20the%20date%20for%20header%20of%20a%20document.%20at%20the%20moment%2F%20it%20only%20uses%20the%20excel%20format%20which%20is%20numbers.%20i%20send%20files%20all%20over%20the%20world%2F%20so%20need%20to%20be%20able%20to%20have%20the%20months%20as%20a%20word.%20i%20figured%20out%20how%20to%20change%20the%20date%20in%20a%20cell%2F%20but%20not%20header.%20help%20please!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1509264%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1509457%22%20slang%3D%22en-US%22%3ERe%3A%20customize%20date%20for%20header%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1509457%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722490%22%20target%3D%22_blank%22%3E%40asia_laurel%3C%2FA%3E%26nbsp%3B%2C%20I%20don't%20believe%20you%20can%20change%20the%20format%20for%20the%20headers.%20One%20workaround%20could%20be%20to%20rename%20the%20sheet%20to%20the%20date%20in%20the%20format%20you%20want%20it%20in%20and%20use%20Sheet%20name%20in%20the%20header.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

i. have been trying to customize the date for header of a document. at the moment/ it only uses the excel format which is numbers. i send files all over the world/ so need to be able to have the months as a word. i figured out how to change the date in a cell/ but not header. help please!!

1 Reply
Highlighted

@asia_laurel , I don't believe you can change the format for the headers. One workaround could be to rename the sheet to the date in the format you want it in and use Sheet name in the header.