Excel connector - retain formatting?

  • 28 November 2023
  • 2 replies

Userlevel 1
Badge +2
  • Newly Minted Pigmenteer
  • 5 replies

Is there a way to retain number formatting in excel when using the Pigment Excel Connector?  I can retain things such as cell borders, colors, etc. but cannot retain number formatting.  Every time I pull data to refresh from Pigment, the number formatting is overridden in my excel workbook.

This is not the case with the Google Sheets connector, which does retain number formatting in cells where Pigment data is being imported.  Does this functionality exist for the Excel connector, or is this a feature request?  


Best answer by Benoit 29 November 2023, 10:01

View original

2 replies

Userlevel 6
Badge +12

Hi Dave,


Many thanks for this question / feedback.

You are right, it is something that the Excel connector does not support at the moment but we’ll look to unlock this limitation in the future.

Our Product team is aware of it and will prioritize it. We’ll come back to you when it will be released.


Many thanks for your understanding.


Userlevel 1
Badge +2

Thanks Benoit for the quick reply.  Understood on the current functionality, and we are looking forward to the team unlocking this limitation.