Solved Custom Formatting for one section number

August 3, 2016 at 13:11:01
Specs: Windows 64
Hi, I have a very interesting question for the forum today.

I have a spreadsheet with a column that has a picklist of numbers ranging from 1 - 5.10. For example the picklist has the following:
1
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
1.10
1.11

2
2.1
etc.

The issue I am running into is when 1.10 and 1.11 is picked from the picklist the number is being displayed as 1.1 and 1.2 instead of 1.10 and 1.11. My manager has made it clear that she doesnt want the other selections to be displayed with an extra decimal point (for example 1 showing as 1.0 etc)

Can this be fixed so that 1.10 & 1.11 is displayed as such without adding a second decimal place to all the others?


See More: Custom Formatting for one section number

Report •


#1
August 3, 2016 at 14:02:46
✔ Best Answer
By "picklist" I assume you mean a Data Validation Dropdown.

If that is correct, format the original number and the Dropdown cell list as Text, not as numbers.

Excel will still be able to use the Dropdown choice in a calculation if need be, but the format of the text in the cells won't be changed.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
August 4, 2016 at 06:22:51
Yes DerbyDad03 you are correct - Data Validation Dropdown. And your solution worked like a charm! Thank you!!!!


Report •
Related Solutions


Ask Question