excel number format
Posted on 2006-10-19
Question about using vb.net to set the format of numbers in excel. Where can I find a list of all the different types of formating available.
Example: .Range("d17:h25").NumberFormat = "$#,##0.00" sets to currency
.Range("d17:h25").NumberFormat = "General" sets to general
.Range("i17:i17").NumberFormat = "Percentage" DOES NOT set to a percent
I'd like to find a link to a list of what to put in the "" for all the different formats possible
Right now I need % but in the future I'll eventually need the rest.