Hi again
I got my all my currancy formats gone.
I can store this as a numbe without changing the formats i got from regional
settings
Thanks in advance
Prash


"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:EDF5C047-5788-44BC-B366-09777524FEC0@microsoft.com...
> Try inserting the following before your line of code:
>
> Cells(1, 1).Value = Cells(1, 1).Value * 1
> --
> Gary''s Student
>
>
> "Prashwee" wrote:
>
>> Hello All
>>
>> I have changed my reginal settings to swedish
>>
>> Then i use the folowing statement in my application
>> ApExcel.Cells(1, 1).value =FormatCurrency("1,00", 2, vbFalse, vbFalse,
>> vbTrue)
>>
>>
>> when i open my Excel sheet, cell 1,1 has a smll green trangle . when i
>> press it it warns "Number stores as text".
>> how do i avoid this. I need to store it as number
>>
>>
>> /Thanks in advance
>> Prash
>>
>>
>>