Forum Discussion
replacing a number with a measure
I have a list of 400 numbers and need to replace them to express them in Measurement form. Like 66 to 66", 80 to 80". Is there a way to do this?
2 Replies
- Use a custom number format like this:
0\" - If you have a particular range of numbers and all of these you want to change in the measure
add a column in front of that particular column and use the upcoming formula next to the first cell of that column if A1 has a value of 30 after using the formula (=A1&""") it will be 30" in measurement. Drag the formula upto the declared range of numbers.
