Pramodpandit123
New Member
- Joined
- Apr 18, 2020
- Messages
- 30
- Office Version
- 2016
- Platform
- Windows
Hello Everybody,
I wanted to change the decimal number (NOT CONVERT) into showing feet and inches using custom cell format.
For eg:
1.If the decimal number is 5.9 then using custom cell format i wanted it to show 5'-9".
2.If the decimal number is 12.11 then using custom cell format i wanted it to show 12'-11".
Can this be achieved through custom cell format or a would it be necessary to use formula to achieve the goal ?
Thank you !
I wanted to change the decimal number (NOT CONVERT) into showing feet and inches using custom cell format.
For eg:
1.If the decimal number is 5.9 then using custom cell format i wanted it to show 5'-9".
2.If the decimal number is 12.11 then using custom cell format i wanted it to show 12'-11".
Can this be achieved through custom cell format or a would it be necessary to use formula to achieve the goal ?
Thank you !