Excel issue but how to get correct data from UiPath

[Vineet_Joshi2 (Vineet Joshi)]

Hi Everyone,
Hope you are awesome

I have a strange issue please this out and let me know solution/suggestion I should try.
I am reading this excel file and I recognized that the comma in the excel are not being picked in Dateable.
When I check the excel file I found this issue suppose this is a excel file :-
a b c
123,00 12 1231

when extracting the a 123.00 value it is extracted as 12300 and in excel file itself this is not accepting this value as 123,00

[Vineet_Joshi2 (Vineet Joshi)]

Check out these images hope you got this issue

[lrtetala (Lakshman Reddy)]

Hi @Vineet_Joshi2

Can you try below

1.If you are using Read Range Workbook activity enable Preserve Format option in properties
2.If you are using Excel activities

Regards,

[Vineet_Joshi2 (Vineet Joshi)]

I am not sure if this can be solved by UiPath as EXCEL itself is not considering it

[rashmisingh2695 (Rashmi)]

Hi @Vineet_Joshi2,

The Format of the selected Cell is number, if you change it to text it will consider comma. Please try this once.

Thanks,
Rashmi

[Vineet_Joshi2 (Vineet Joshi)]

Its still the same no change

[rashmisingh2695 (Rashmi)]

Hi @Vineet_Joshi2 ,

You can try the solution shared by Lakshman, it should work.
In excel the cell formatting affects only the display of the number in the cell, not the actual value stored.
So, the actual value stored in your file is 200000 but because of formatting it showing as 200,000