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.
SolidworksBill Of Materials