Page 1 of 1

Unlocking specific cells on configuration spreadsheet

PostPosted:Sun Sep 14, 2014 6:04 am
by dbarnwell
We are trying to unlock a cell to allow for formatting of a percentage in the configuration page allowing for 2 places, i.e. 22.8% instead of 23%. The cell I am trying to revise is O19

Re: Unlocking specific cells on configuration spreadsheet

PostPosted:Sun Sep 14, 2014 5:55 pm
by DashboardWidgets
Hi dbarnwell

We have updated the original version of the spreadsheets so that the thermometer function is now available in either a rounded number or one decimal place (the number on the thermometer bulb is currently shown as a rounded number and the larger number to the right is shown with one decimal place - if you want to both shown with one decimal place just use the code for the text on the right in the thermometer bulb).
(632.5 KiB) Downloaded 953 times
Here's a quick image..
Decimal Places.jpg
Unfortuantely you'll need to import your work into the new spreadsheet format that has this functionality. Alternatively, feel free to send me your spreadsheet (fred@exceldashboardwidgets) and I will update the functionality and send it back to you.

Hope this helps and please get back in touch if you need any more support.

Cheers

Fred

Just the Job

PostPosted:Tue Sep 16, 2014 3:19 am
by dbarnwell
Just the job. Thanks.