how to create custom number format permanently

%3CLINGO-SUB%20id%3D%22lingo-sub-1280352%22%20slang%3D%22en-US%22%3Ehow%20to%20create%20custom%20number%20format%20permanently%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1280352%22%20slang%3D%22en-US%22%3EHello%20all%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ei%20tried%20to%20create%20a%20custom%20number%20format%20in%20format%20cells%20in%20microsoft%20excel%20yesterday.%20but%20unfortunately%2C%20the%20new%20created%20number%20format%20only%20appear%20in%20my%20worksheet%20that%20i%20saved%20earlier.when%20i%20tried%20to%20open%20a%20new%20excel%20worksheet%2C%20the%20number%20format%20not%20appear%20in%20the%20custom%20type%20anymore.%20how%20can%20i%20create%20it%20permanently%3F%20can%20anyone%20guide%20me%20how%20to%20make%20sure%20the%20changes%20apply%20to%20the%20new%20worksheet%20without%20retype%20the%20same%20number%20format.%20thank%20you.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1280352%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
Hello all,

i tried to create a custom number format in format cells in microsoft excel yesterday. but unfortunately, the new created number format only appear in my worksheet that i saved earlier.when i tried to open a new excel worksheet, the number format not appear in the custom type anymore. how can i create it permanently? can anyone guide me how to make sure the changes apply to the new worksheet without retype the same number format. thank you.
0 Replies