I am putting together a spread sheet and have like 4-5 cells where the number entered will always be in inches. Is there a way to do a custom number format so the people entering can add a number and the " will be added automatically. Similar to currency where you add 500 and $500 shows. Thanks!
Last edited by sp1974; 04-18-2011 at 10:07 AM.
try this in custom format:
0.00"''"
I'm not sure is it correct but it would show you for example 5,432"
Last edited by zbor; 04-18-2011 at 09:45 AM.
Never use Merged Cells in Excel
How about...
0\"
HTH
Regards, Jeff
Not sure if you need only whole numbers or not so that it doesn't round....but for 2 decimal places(adjust format as needed for more or less)......
0.00\"
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
both worked. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks