Hello All,
Is it possible to create a custom number format that will display a custom unit in the cell next to the number? I would like to display Watts with the number directly in the cell and still be able to use the number in a calculation.
I realize that I could put the units in a column next to the number.
Thank you
Last edited by mcclanat; 04-09-2012 at 10:50 AM.
right-click on the cell, go to custom formats, and add 0 w
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Change the format to, for example, General"W"
Entia non sunt multiplicanda sine necessitate
Hi,
Yes, just format the cell as
"watts" 0
or
0 "watts"
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks