The
VB is correct: 15 is 1500% and .15 is 15%. It is one of those quirky,
and sometimes annoying, functions of entering values into cells. Excel tries
to outguess us. Typing in whole numbers Excel decideds that we are typing in
the percent (see the percent sign appear as you type?) Type in a decimal
point first and Excel decides we are entering the actual numeric value.
Great huh?
In electrical wiring there is an annotation for cables. (I'm not an
electrical engineer), annotation examples are 1/0 (one-ought), 2/0
(two-ought), 4/0 (four-ought), etc., which represents number of wires and
wire size (I think.) Try typing that in. Excel thinks I'm typing a date!
I'm trying to help an EE solve this pain-in-the-butt problem. Changing the
cell to Text causes VLOOKUP errors elsewhere.
"JLGWhiz" wrote:
You can disregard the previous posting. I just noticed an odd occurrence.
If I manually enter 15 or .15 either will give me 15% displayed. However, if
I enter the amount in code as 15 it gives me 1500% and 0.15 gives me 15%
displayed. This has to be an Excel/VBA bug. I am going to check the
Microsoft site for any alerts on this.
"Tony Girgenti" wrote:
Hello.
I'm using VB6.0, SP6 and Excel 2003, SP3.
I'm formatting a worksheet column and then filling the columns with data.
The format gets applied, but the data is not appearing as expected. These
lines of code are what i am using to format the column with a Percent.
newExcelWorkSheet.Columns("D").NumberFormat = "0.00%"
newExcelWorkSheet.Columns("D").HorizontalAlignment = xlCenter
When i open the Excel workbook, the data is there and those cells show it
formatted as Percent with 2 decimals. The data is sent to the value of the
cell as "015.00"(without the quotes), yet when open the workbook, it appears
as 015.00. I was expecting it to appear as 15.00%.
The HorizontalAlignment works. Why is the data not appearing as a percent?
If i open the workbook and put 015.00 in one of the formatted cells, it does
appear as 15.00%.
Any help would be gratefully appreciated.
Thanks,
Tony