SOLVED

Format cell to custom but it wont hold it

%3CLINGO-SUB%20id%3D%22lingo-sub-3529515%22%20slang%3D%22en-US%22%3EFormat%20cell%20to%20custom%20but%20it%20wont%20hold%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3529515%22%20slang%3D%22en-US%22%3E%3CP%3EI%20format%20a%20cell%20to%20%22general%22%20and%20I%20put%20two%20numbers%20in%20the%20cell%20separated%20with%20a%20%2F.%3C%2FP%3E%3CP%3EIt%20will%20hold%20the%20%22general%22%20format%20until%20the%20numbers%20I%20input%20corresponds%20to%20months%20of%20the%20year%2C%20then%20it%20automatically%20changes%20the%20format%20to%20%22custom%22%20and%20changes%20the%20numbers%20to%20month-day.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20stop%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3529515%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3530004%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20cell%20to%20custom%20but%20it%20wont%20hold%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3530004%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1430208%22%20target%3D%22_blank%22%3E%40RICKEY160%3C%2FA%3E%26nbsp%3BFormat%20the%20cell(s)%20as%20text%20first%20if%20you%20don't%20want%20Excel%20to%20automatically%20switch%20to%20what%20Eit%20thinks%20you%20want%20to%20use%20as%20a%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3532908%22%20slang%3D%22en-US%22%3ERe%3A%20Format%20cell%20to%20custom%20but%20it%20wont%20hold%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3532908%22%20slang%3D%22en-US%22%3EThanks%2C%20that%20works.%20applicate%20your%20help.%3C%2FLINGO-BODY%3E
New Contributor

I format a cell to "general" and I put two numbers in the cell separated with a /.

It will hold the "general" format until the numbers I input corresponds to months of the year, then it automatically changes the format to "custom" and changes the numbers to month-day. 

How do I stop this?

2 Replies
best response confirmed by RICKEY160 (New Contributor)
Solution

@RICKEY160 Format the cell(s) as text first if you don't want Excel to automatically switch to what Eit thinks you want to use as a format.

Thanks, that works. applicate your help.