> Hi Allan,
>
> See at front, in the cell I am getting value as 0.107 but when u
> clicks on that cell, in the formula bar u can see the actual value
> which is 0.10665. But I think DTS picks up the formatted value and not
> the actual value. Can we some how pick up the actual value and not the
> formatted value??? Please suggest.....
>
> Thanks any ways for reply.
> Kedar
> On Nov 30, 3:05 am, Allan Mitchell <a...@no-spam.sqldts.com> wrote:
>
>> Hello risbudke...@gmail.com,
>>
>> You could write code to change Excel but you just said you can't do
>> that.
>>
>> As for the data that comes out of Excel.
>>
>> How do you manage to have in the cell the value 0.10665 if the cell
>> is formatted to 3 decimal places. In my XL it gets pushed to 0.107
>>
>> Regards
>>
>> Allan Mitchell
>> Konesans Ltd
>> T +44 7966 476 572
>> F +44 2071 008 479http://www.konesans.com
>>> Hi,
>>>
>>> I am working on DTS. I am transforming data from Excel to SQL Server
>>> through DTS. The problem I am facing right now is, in excel I have
>>> some
>>> value as 0.10665 but that cell is formatted as to take up to 3
>>> decimals
>>> so its coming as 0.107 but while transformation I want 0.10665.
>>> Simple solution to this problem is to change the excel cell format.
>>> But
>>> I cannot change excel.
>>> So can we write any activeX script by which we can change the format
>>> of
>>> excel??? If yes where can I get this code.
>>> Thanks in advance,
>>> Kedar- Hide quoted text -- Show quoted text