decimal value changes when fetched using VBA

[bvijaybhargav]

Hi Experts,

I have a situation where i need to fatch a decimal value using VBA.

In the excel cell, the value is 0.0121066855433171
But when i fetched using thisworkbook.worksheets("Sheet1").Range("A1").Value , its returning as 1.2335648232275E-03

This is hampring my task.
Can any one please tel me how to proceed

Thanks
Vijay Bhargav

[jonboy6257]

Do you have a sample workbook or a sample of your code by chance?

[bvijaybhargav]

Yes.
In the sample workbook,

A1 B1
0.0121066855433171 0.0012335648232275


My Code i am trying
Function test
beforeVal = ThisWorkbook.Worksheets("Before").Range(cCol & beforeRow).Value
''perform some logic
msgbox beforeVal
End Function

in the msgbox, insted of printing 0.0121066855433171 its showing 1.2335648232275E-03.

I need it exactly because i have to put it in reporting. value should not be changed.


Thanks In advance

Vijay

[jonboy6257]

It is showing 0.0012335648232275 but in exponential notation. What format do you have set on the cell it is being copied into, and a workbook would be great if your able to upload it.