Issues when copying & pasting to excel

Altair Forum User

I have an issue when copying and pasting to excel that just arose in the newer versions.  When I have data in Monarch that contains an employees number, for example, that has leading zeros (0036).  In my Monarch table it look correct.  When I use to copy the information over to excel, if I would paste, special, text, the information would paste into excel correctly (0036).  Now with the current version of Monarch, no matter how I paste or format the number it still shows up as 36 not 0036.  I am curious why it worked in older versions of Monarch, but not the current version.  Any suggestions how I can paste the information correctly? 

 

Thank you in advance

Brian Stimpson

Altair Forum User

Hi Brian,

 

We are reinstating the copy to excel with formats in the soon to be released version of Monarch.

 

HTH

Mela

Altair Forum User

Brian,

 

In the meantime, you could try formatting the column in Excel that is going to have the employee numbers to "Text" instead of general, then copy it in from Monarch. I believe that this should work.

 

Regards,

 

Austin

Altair Forum User

Altair Forum User said:

Brian,

 

In the meantime, you could try formatting the column in Excel that is going to have the employee numbers to "Text" instead of general, then copy it in from Monarch. I believe that this should work.

 

Regards,

 

Austin

Austin,

 

Thanks for your suggestion, however it was already tried.  The information stays the same regardless if I reformat it to text. I.E. employee # 0009, when copied and pasted into excel shows as 9.  When you reformat the cells to text, it still shows as 9 rather than my desired result of 0009.

 

I know I can do a formula cell etc etc, but it should be much easier, like it use to be in the past.  I try not to create too complex models in case they break or the data source changes as it makes it easier to fix.

 

Brian

Altair Forum User

Altair Forum User said:

Hi Brian,

 

We are reinstating the copy to excel with formats in the soon to be released version of Monarch.

 

HTH

Mela

I look forward to this change.  Thanks Mela

Altair Forum User

Altair Forum User said:

Austin,

 

Thanks for your suggestion, however it was already tried.  The information stays the same regardless if I reformat it to text. I.E. employee # 0009, when copied and pasted into excel shows as 9.  When you reformat the cells to text, it still shows as 9 rather than my desired result of 0009.

 

I know I can do a formula cell etc etc, but it should be much easier, like it use to be in the past.  I try not to create too complex models in case they break or the data source changes as it makes it easier to fix.

 

Brian

Brian,

 

I was thinking I was able to do this before so I went back and was able to recreate the desired result. I've included some screenshots for reference. In Excel, I formatted the column to text before I pasted in the values and they kept their leading zeros.

 

Let me know if this doesn't help and maybe we can connect and walk through it.

 

Austin