The error you’re encountering during a CSV import into NetSuite can often happen when numeric fields contain values that are formatted inconsistently or include non-numeric characters, such as commas, periods, or spaces. To handle these kinds of errors, you can use the NUMBERVALUE() function in Excel or Google Sheets to standardize numeric values in the CSV file before importing it into NetSuite.
Explanation of NUMBERVALUE()
NUMBERVALUE() is a function available in Excel and Google Sheets that converts text to a numeric value, while allowing you to specify a decimal separator and grouping separator (e.g., commas for thousands). This is useful for ensuring that values in your CSV file are formatted correctly for NetSuite import.
Syntax:
excel Copy code NUMBERVALUE(text, [decimal_separator], [group_separator])
text: The text you want to convert to a number.decimal_separator(optional): The character used as the decimal point in the number.group_separator(optional): The character used as the thousands separator in the number.