davexpc
04-06-2009, 03:31 AM
Hi there!
I was developing my macro in excel 2007 and it was working perfectly but when I tried it in the 2003 version it didn't work because of a format conversion!
The problem is that I write a number in a cell using the percentage format (xlpercentage) so instead of writing 0.05, I write 5.00%
Later in my program, I need to work with that number but when I do
MyRate = ActiveCell.Value (MyRate is defined as double and active cell has the percentage number)
It doesn't work. If I define MyRate as string, the line works but obviously I can't make any calculation with it. Like I said, in the 2007 version there was not any problem.
Any advice?
Thanks in advance!
David
I was developing my macro in excel 2007 and it was working perfectly but when I tried it in the 2003 version it didn't work because of a format conversion!
The problem is that I write a number in a cell using the percentage format (xlpercentage) so instead of writing 0.05, I write 5.00%
Later in my program, I need to work with that number but when I do
MyRate = ActiveCell.Value (MyRate is defined as double and active cell has the percentage number)
It doesn't work. If I define MyRate as string, the line works but obviously I can't make any calculation with it. Like I said, in the 2007 version there was not any problem.
Any advice?
Thanks in advance!
David