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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies