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
Answers
-
Hi Brian,
We are reinstating the copy to excel with formats in the soon to be released version of Monarch.
HTH
Mela
0 -
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
0 -
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
0 -
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
0 -
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
0
