Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with double value
I have a xml document, and one of it's values is a number in the format 1,5. And i need to insert in a excel cell that value * an integer, the problem is that when i convert 1,5 to double i got 15 instead of 1.5. I tried modifying the format of the number to 1.5 or replacing the , with a . but with no success. If i don't convert the number to double i got only 1. Now i convert 1.5 to 15 and then multiply it by the integer and then divide it by 10. It works, but it's not elegant, and the thing is that in the xml document i can have 1,5 or an integer, and in that case i can't divide by 10. So i need to compare the number in search of a , before converting it. Is there any way around more elegant? Thanks, -- Jlorga ------------------------------------------------------------------------ Jlorga's Profile: http://www.excelforum.com/member.php...o&userid=31707 View this thread: http://www.excelforum.com/showthread...hreadid=517324 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with double value
Sub Macro3() ' ' Macro3 Macro ' Macro recorded 2/28/2006 by Dave ' ' Selection.Replace What:=",", Replacement:=".", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False ActiveCell.Offset(0, 0).Range("A1").Select End Sub I just copied this macro from the recorder, insert it into a module and assign a button to it, highlite a range you want edited and then press the button -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=517324 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
double axis, double problem (i hope only to me) | Charts and Charting in Excel | |||
Cell double-clicking problem | Excel Discussion (Misc queries) | |||
Double entry problem | Excel Discussion (Misc queries) | |||
Double Subtotal Problem {Excel 2000} | Excel Programming | |||
Formatting Problem on Double-Zero String | Excel Programming |