I have vlookups and match functions pointing to a templated field
where the user types in the number. After the user types in the ref
number the formulas still show #N/A. The formulas will only update
for values once I use Text to Columns to change the field to General
format. Is there a way where this does not need to happen?