Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to get exact decimal value.
Hi,
I'm writing a macro to expedite my project work. I need little help from you. I'm using a multidimensional array to capture data from excel spread sheet. The fields hold values in decimal, i.e. 33.5462 and so. Now my concern is that when I run the following code - para_code(v_i, h_i) = Val(ActiveCell.Value) I get an whole value, i.e. 34 instead of 33.5462. Please let me know how to transmit the value as it is. Thanks a lot in advance!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to get exact decimal value.
How did you declare para_code()?
As Double or as Long? Alwyn wrote: Hi, I'm writing a macro to expedite my project work. I need little help from you. I'm using a multidimensional array to capture data from excel spread sheet. The fields hold values in decimal, i.e. 33.5462 and so. Now my concern is that when I run the following code - para_code(v_i, h_i) = Val(ActiveCell.Value) I get an whole value, i.e. 34 instead of 33.5462. Please let me know how to transmit the value as it is. Thanks a lot in advance!!! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want to get exact decimal value.
Oh!!!
Now i realise my mistake i had declared para_code() as integer. I can now fix it. Thanks a lot Mr. Peterson. __________________________________________________ _______________________ Dave Peterson wrote: How did you declare para_code()? As Double or as Long? Alwyn wrote: Hi, I'm writing a macro to expedite my project work. I need little help from you. I'm using a multidimensional array to capture data from excel spread sheet. The fields hold values in decimal, i.e. 33.5462 and so. Now my concern is that when I run the following code - para_code(v_i, h_i) = Val(ActiveCell.Value) I get an whole value, i.e. 34 instead of 33.5462. Please let me know how to transmit the value as it is. Thanks a lot in advance!!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
h:mm to decimal value | Excel Discussion (Misc queries) | |||
Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
decimal point override does not work | Excel Discussion (Misc queries) |