Home

Problem with formatting cell content

%3CLINGO-SUB%20id%3D%22lingo-sub-740835%22%20slang%3D%22en-US%22%3EProblem%20with%20formatting%20cell%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740835%22%20slang%3D%22en-US%22%3E%3CP%3ECell%20format%20defaults%20to%20text%2C%20does%20not%20respond%20to%20choosing%20the%20currency%20option%20in%20formats.%20Please%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740835%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740860%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20formatting%20cell%20content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740860%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F372010%22%20target%3D%22_blank%22%3E%40Avril10%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDefault%20cell%20format%20is%20General%2C%20it%20could%20be%20converted%20to%20Text%20automatically%20if%20you%20return%20texts%20to%20cells%20by%20formula%20or%20by%20copy%2Fpaste.%20Applying%20currency%2C%20number%20and%20like%20format%20to%20such%20cells%20won't%20convert%20texts%20to%20numbers%2C%20you%20shall%20do%20that%20by%20another%20way.%20If%20you%20provide%20bit%20more%20details%2C%20desirably%20at%20least%20screenshort%20or%20better%20sample%20file%2C%20it%20could%20be%20more%20concrete%20advise.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Avril10
Occasional Visitor

Cell format defaults to text, does not respond to choosing the currency option in formats. Please help!

1 Reply

@Avril10 

 

Default cell format is General, it could be converted to Text automatically if you return texts to cells by formula or by copy/paste. Applying currency, number and like format to such cells won't convert texts to numbers, you shall do that by another way. If you provide bit more details, desirably at least screenshort or better sample file, it could be more concrete advise.