Home

Excel cell custom format disappears

%3CLINGO-SUB%20id%3D%22lingo-sub-1116289%22%20slang%3D%22en-US%22%3EExcel%20cell%20custom%20format%20disappears%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116289%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20set%20up%20a%20custom%20cell%20format%20in%20Excel%20to%20be%20there%20permanently.%26nbsp%3B%20It%20is%3A%26nbsp%3B%20%26nbsp%3B%22%22%40%22.jpg%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20easily%20type%20it%20in%20each%20time%20but%20I%20need%20it%20to%20stay%20in%20the%20General%20Custom%20box%20permanently.%26nbsp%3B%20Unfortunately%20it%20disappears%20each%20time%20after%20I%20use%20it%20once.%26nbsp%3B%20How%20do%20I%20make%20it%20become%20a%20permanent%20part%20of%20my%20Custom%20cell%20formula%20collection%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETandalatom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1116289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116355%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20custom%20format%20disappears%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116355%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F523633%22%20target%3D%22_blank%22%3E%40Tandalatom%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20suggest%20creating%20an%20Excel%20Template.%20To%20create%20a%20template%20open%20a%20blank%20workbook%2C%20make%20changes%20to%20anything%20that%20you%20commonly%20change%20in%20new%20workbooks%20(i.e.%20custom%20format%26nbsp%3B%3CSPAN%3E%22%22%40%22.jpg%22)%20and%20save%20as%20an%20Excel%20Template.%20These%20sorts%20of%20changes%20will%20be%20retained%20within%20the%20template.%20Each%20time%20you%20want%20to%20create%20a%20new%20workbook%20that%20has%20the%20custom%20format%26nbsp%3B%22%22%40%22.jpg%22%20already%20available%2C%20simply%20open%20your%20template.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116455%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20custom%20format%20disappears%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116455%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3B%20Thanks%20much.%26nbsp%3B%20That%20does%20retain%20the%20formula.%26nbsp%3B%20Now%20I%20need%20to%20get%20used%20to%20using%20it!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETandalatom%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116529%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20cell%20custom%20format%20disappears%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116529%22%20slang%3D%22en-US%22%3EMy%20pleasure!%3C%2FLINGO-BODY%3E
Tandalatom
New Contributor

I want to set up a custom cell format in Excel to be there permanently.  It is:   ""@".jpg"

 

I can easily type it in each time but I need it to stay in the General Custom box permanently.  Unfortunately it disappears each time after I use it once.  How do I make it become a permanent part of my Custom cell formula collection?

 

Tandalatom

3 Replies
Highlighted

Hello @Tandalatom,

 

I would suggest creating an Excel Template. To create a template open a blank workbook, make changes to anything that you commonly change in new workbooks (i.e. custom format ""@".jpg") and save as an Excel Template. These sorts of changes will be retained within the template. Each time you want to create a new workbook that has the custom format ""@".jpg" already available, simply open your template.

Highlighted

@PReagan  Thanks much.  That does retain the formula.  Now I need to get used to using it!

 

Tandalatom

Highlighted
My pleasure!
Related Conversations
OLD WEB feeds
AndyM2 in Excel on
0 Replies
Can anyone make this dependent?
novakdz in Excel on
6 Replies
'If' statement help needed
Ollie1785 in Excel on
6 Replies
additionner grille de commande
Gaetan205 in Excel on
0 Replies