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
Highlighted
Avril10
Occasional Visitor

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

1 Reply
Highlighted

@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.