Solved

how to show 0% in excel with a vb.net

Posted on 2014-11-21
1
123 Views
Last Modified: 2014-11-21
My code is not allowing me to populating 0%. The cell is just showing % for 0%. Any tips?

Code:

    .Range("D:D").NumberFormat = "##%"
0
Comment
Question by:cmed
1 Comment
 
LVL 20

Accepted Solution

by:
dsacker earned 500 total points
Comment Utility
Try:

.Range("D:D").NumberFormat = "#0%"
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now