Hi,
I have a number of cells with data like the following;
10,12,14
8,10,12
18.75,18.75,18.75
How do I create one custom format so the end result is this:
10mm, 12mm, 14mm
8mm ,10mm ,12mm
18.75mm ,18.75mm ,18.75mm
i can get the custom format to work for the first two but through the decimal point in and it hates it
I have a number of cells with data like the following;
10,12,14
8,10,12
18.75,18.75,18.75
How do I create one custom format so the end result is this:
10mm, 12mm, 14mm
8mm ,10mm ,12mm
18.75mm ,18.75mm ,18.75mm
i can get the custom format to work for the first two but through the decimal point in and it hates it