Set number of decimal places displayed when data in a cell is concatenated with text.
For example = "L/V = "& E15. Cell E15 contains a calculated value.
Also set NDP when text and data is dynamically referenced in a text box that has been added to a chart.
Use the TEXT() function to convert the number to text in the desired format. See discussion and examples in help file: https://support.office.com/en-us/art...8-93d29371225c
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks