u/Spreadsheet_Geek_1

Hello,

is there a way to get an autonumber assigned to each row, but then turn it into a string with leading zeros, so that it is always the same length, that I can potentially concatenate with some prefix or suffix?

I managed to do prefix + autonumber in a calculated field, but it doesn't have leading zeros and the calculated field simply does not take in the Format() function.

The goal is to maintain the reliable non-duplication of autonumber, but be able to work with it like a string and be able to sort it alphanumerically.

I have downloaded a third party Excel spreadsheet with power query in it (specifically for the power query as a template).

Now, no attack is expected, but I'm simply skeptical by nature and want to learn anyways, so I'd like to get a hold of the code, as if I opened the power query advanced editor, before the PQ has any sort of permission in my system to run and or do anything.

How can I achieve this? When I try to open the Power Query window, it already seems to ask me to give the permission to run, just to get in there.

Hello,

I have a rather important PDF file, that used to work just fine. Now when I open it in PDF Xchange, it says "Converting file: <filename>" and does a loading animation. Than the PDF opens as just a page filled with dots (with a different format of the page too). No text, no graphics, like if you just opened a word document and held down the dot key for a minute.

I have a backup somewhere, but I've already put some annotations into this one, so it'd be handy, if it can be restored.

Thanks in advance for your answers.