Excel Format Changes

Help Studio
, ,
1

Hi ,
So i got a case , where when i copy a data from 1 excel then write that data to another excel,
somehow a couple of cell have diffrent format

example
original excel value : 22-jan-2022 with format of date
new excel file : on that column i set the format as “general” and most data will have format of “general” but some cell will still have format of “Date”

thank you

2

Hi @Ahmad_Rais,

On the new excel where you want to write by default set the predefined format you want. If that is not working you can use invoke vba, create a VB and post performing the business logic you can run the VB to reset the formats.

Thanks,
Shikhar

3

Hi already done that still error , i might need to use assign for each column to see if format date is detected then will have to change it

thanks for the helps
ahmad

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.