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!!! |
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) |