This isn't a Pipelines or QB item - that just Excel being Excel. Especially since you're downloading it as a CSV - Excel will never understand the formatting aspect given that CSV's by their nature don't have formatting - it's just the value.
You could try sending the value as a formula, I've seen some success with that. So when you pass it in - pass it in as a string that looks like ="{{part number}}" and see if that works to force Excel when it opens to render it as a number.
Really the only good option is to not actually open Excel by default - but to open a new worksheet and load data from a CSV so that Excel will understand when it reads the data that it needs to interpret it as text as opposed to trying to guess.
Chayce,
Thanks, that didn't work either. I may try Google Sheets and then bring it back into QB.
What is the end result you're looking for? Are you sending out an Excel file for someone to make edits to then pass back into Quickbase? Just curious what role Google would play in this scenario to see if there might be a third door to consider as well.
Chayce,
When we are done adding PNs to our BOM, we generate the BOM in Excel.cvs with headers the manufacturer wants to see. When we are ready, we click a button to generate the BOM, ECN and all drawings.
Recently, the manufacturer sent the BOM back to us claiming incorrect PN for a select few.
Google Sheets may not create this anomaly. As I mentioned earlier, some PNs are alphanumeric, and some are numeric. Meanwhile, numeric PNs are correct until they are added to an Excel sheet.
