DDD Posted December 10, 2020 Share Posted December 10, 2020 Hi I have a question regarding the worksheet cell formatting. Let's say the document unit is set to 'feet', and I have an one-feet long line that I want to put into a report reflecting its length. Is there anyway I can show its length as "12 inches" instead of "1 feet" in the worksheet without changing the document unit settings? Thank you. Quote Link to comment
Pat Stanford Posted December 11, 2020 Share Posted December 11, 2020 I think you have to do it the old fashioned way and do the math and set the Suffix to the units manually. For Feet and Inches in cell B3 that you want to show as Inches, it would be B3*12 and then Format the cell as Decimal and set the trailer to " Inches" (note the space in front of Inches). Other conversions for other units. These formulas and formats can be done in Database Header cells and apply to the entire database column. 1 Quote Link to comment
DDD Posted December 11, 2020 Author Share Posted December 11, 2020 @Pat Stanford Thank you Pat! Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.