Issues when copying & pasting to excel
Altair EmployeeI 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
Find more posts tagged with
Altair EmployeeBrian,
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 EmployeeBrian,
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 EmployeeHi 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 EmployeeAustin,
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
Hi Brian,
We are reinstating the copy to excel with formats in the soon to be released version of Monarch.
HTH
Mela