atuljadhavnetafim
Active Member
- Joined
- Apr 7, 2012
- Messages
- 341
- Office Version
- 365
- Platform
- Windows
Dear Expert
I have 8 columns in which the first four columns show value in INR and the rest four value in USD, so in presentation, I need to put this entire 8 column to present.
now I want to show value in INR and USD in single-cell but the formation of INR and USD must be different, like INR value shown in Blue color and font 10 sizes while USD value in Green color and font 8 sizes.
Currenlty show as below.
expected result
Excel allow me to change the color and font size but when i exit the cell it is not reflected in display.
any way to show in single cell INR and USD value with different formatting .
Best of luck and Thanks in advance
I have 8 columns in which the first four columns show value in INR and the rest four value in USD, so in presentation, I need to put this entire 8 column to present.
now I want to show value in INR and USD in single-cell but the formation of INR and USD must be different, like INR value shown in Blue color and font 10 sizes while USD value in Green color and font 8 sizes.
Currenlty show as below.
expected result
Excel allow me to change the color and font size but when i exit the cell it is not reflected in display.
any way to show in single cell INR and USD value with different formatting .
Best of luck and Thanks in advance