Forum Discussion
ChayceDuncan
7 months agoQrew Captain
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 Duncan
------------------------------