SOLVED

How to insert symbols and numbers in same cell

Iron 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

@Excel 

Apply the custom number format

 

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

 

to the cells. See the attached version.

 

It worked! Thank you so much Sir:smiling_face_with_smiling_eyes::smiling_face_with_smiling_eyes:
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@Excel 

Apply the custom number format

 

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

 

to the cells. See the attached version.

 

View solution in original post