I'm having the same problem, and yes I've made the column width wider and still am getting the "#####" instead of the 100% showing. Anything entered that is less than 100%, such as 99% displays correctly.Hi lalande,
Welcome to the forum, it's difficult to see exactly from your picture, but have you tried making the column width wider?
Hi SirJB7 - Thanks for the reply to my question. The link I used to download the product was provided via an email after my purchase information was completed:Hi, Donna!
As a new user you might want to (I'd say should and must) read this:
And regarding your issue, could you please post the download link?
Hello Narayan - Thanks for the reply. As this is occurring in the Portfolio dashboard I purchased from Chandoo.org, I didn't create the formula. The macros are already included in the dashboard when it is downloaded and so I didn't change anything beyond making the column wider on the off chance that the "####" displaying instead of the 100% entered might be only be related to the size of the data entered - which as mentioned didn't work.Hi Donna ,
When ever you see a display such as #### , just place the cursor in that cell , and press F2 and F9 ; this will show you what the real calculated value is ; after you have seen the value , press the ESC key to leave the formula , if any , as it is.
If you can post the formula which is giving you this display , we can solve the underlying problem.
Hi Narayan - Yes I did and what is showing is 100% in the spreadsheet, but when the information is pulled into the dashboard the "####" is what is displayed.Hi Donna ,
Thanks for giving the background information. I never suggested that you have created the formula ; I am interested to know what the cell contains.
Have you tried pressing F2 and F9 , and seen what the cell contains ?
Hi Narayan - Yes I was referring to the actual project activities info entered into the spreadsheet table on the Project Plans tab and not the "hidden" Calculation tab. I just tried reducing the font size and that didn't work either, the decimal places are already set to zero so I can't adjust that.Hi Donna ,
I hope when you say it shows 100% in the spreadsheet , you are referring to the dashboard , and not some calculation tab from where this figure is being retrieved. If not , please check on the dashboard itself.
Please note that all you can do is to reduce the number of decimal places in the cell format ; if the column width is insufficient to display the value in the formatted font size and number of decimal places , all you can do is :
1. Reduce the font size
2. Reduce the number of decimal places.
Hi Narayan - Please see above for replies to each of your questions and here is the formula contained in the cell on the Calculations tab: =IFERROR(INDEX(lstPlans,$C29,G$27,$C$22),"")Hi Donna ,
So you are confirming :
1. You reduced the decimal places to 0. They were already set to 0, so I didn't have to change that.
2. You increased the column width to a reasonably large setting. Yes
3. The cell does not contain a formula. Not in the spreadsheet, but it does have a reference and formula on the calculation tab, which is "hidden" and I've not changed anything in.
4. The cell contains the value 100% Yes - the spreadsheet has the cells already formatted to display as percentage, so when I enter 100 it displays as 100%
If all of the above is correct , then the only conclusion is that the value is padded with blanks either trailing or leading. Also , the value is being put in that cell by means of a macro.
Can you check either of these ?
Hi, Donna!Hi SirJB7 - Thanks for the reply to my question. The link I used to download the product was provided via an email after my purchase information was completed:
Thanks, I appreciate it.Hi, Donna!
I edited your posted link since even it has expired for downloading, it exposed your personal information.
When I ask you to post the download link I assumed it was a free download one, I apologize for not having warned you before. In general terms you shouldn't post links to commercial software.
Now regarding your issue I hope you could solve it within this thread.
NarayanDownload the project management dashboard excel file
Unlike other downloads on Chandoo.org, this file is locked. You can purchase unlocked version along with 23 other project management templates – Click here to buy it.