SOLVED

How to insert symbols and numbers in same cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2338812%22%20slang%3D%22en-US%22%3EHow%20to%20insert%20symbols%20and%20numbers%20in%20same%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2338812%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(3024).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279347iEB131B21703217A4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(3024).png%22%20alt%3D%22Screenshot%20(3024).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHow%20do%20I%20get%20constant%20dollar%20symbol%20on%20the%20right%20side%20of%20every%20cell%20and%20number%20on%20the%20left%20side%20of%20the%20cell.%20How%20do%20I%20enter%20any%20other%20symbol%20and%20number%20in%20same%20cell%20on%20different%20sides.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EPlease%20help..%3F%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHere%20is%20the%20attached%20file.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2338812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2338862%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20symbols%20and%20numbers%20in%20same%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2338862%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F811137%22%20target%3D%22_blank%22%3E%40Zan_Hanifee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EApply%20the%20custom%20number%20format%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E_(%23%2C%23%230.00*%20%22%24%22_)%3B_((%23%2C%23%230.00*%20%22%24%22)%3B_(%22-%22%3F%3F*%20%22%24%22_)%3B_(%40_)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eto%20the%20cells.%20See%20the%20attached%20version.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2338866%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20symbols%20and%20numbers%20in%20same%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2338866%22%20slang%3D%22en-US%22%3EIt%20worked!%20Thank%20you%20so%20much%20Sir%3Asmiling_face_with_smiling_eyes%3A%3Asmiling_face_with_smiling_eyes%3A%3C%2FLINGO-BODY%3E
Frequent Contributor

Hello Everyone,

Screenshot (3024).png

 

How do I get constant dollar symbol on the right side of every cell and number on the left side of the cell. How do I enter any other symbol and number in same cell on different sides.

 

Please help..??

 

Here is the attached file.

 

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Zan_Hanifee 

Apply the custom number format

 

_(#,##0.00* "$"_);_((#,##0.00* "$");_("-"??* "$"_);_(@_)

 

to the cells. See the attached version.

 

It worked! Thank you so much Sir