|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:
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?