Paste special formats changes (colors) formats (number into date)

[Jambon95]

Hi team,

I looked for it but couldn't find answer hence me asking.

I'm manipulating datas with standard filled colors (no conditional). Now if i copy then "paste special-> formats", it happens sometimes that colors in destination spreadsheets are not the same as original one (using microsoft office 365 proplus). Would you have a fix? This was fixed below.

Now always with same spreadsheet, the paste special-> format changes decimal numbers into dates, can you help me fix this?

Thanks,
Jambon

[Jambon95]

I found a way, went in Page layout/Colors and defined a Custom style. Reuse this custom style in destination spreadsheet worked.

Cheers Help needed change in original post