AnsweredAssumed Answered

BOM Table Equation converting File Name to a scientific-number

Question asked by Matt Lapointe on Oct 13, 2015

I am using an equation in a BOM table column that concatenates the File Name with Configuration Name (i.e. =SW-FileName{}SW-ConfigurationName).  However, we have a file name with the format "101E0050", and when using this in the equation, SW considers this to be a scientific number and expands it out (i.e. adds 50 zeros to the end of 101: 10100000000...). It only does this as soon as I add the {} after the file name variable. Is there any way to force it to keep the file name as text rather than a number?  I know this can be done in Excel easily. Thoughts?

FYI - Using 2015 SP03.

Outcomes