Microsoft Excel and Google Sheets frequently offer very similar functions, though sometimes there are small differences in names and details. In this article, we will focus on the “NUMBERVALUE” function in Excel and its Google Sheets counterpart “SAYIDEĞERİ”. These functions are used to convert numbers formatted as text into numerical values, which is extremely useful for various applications and data processing tasks.

Obtaining Numerical Values

In both programs, the function serves the important purpose of converting text-formatted numbers into real numerical data, which enables computations. This functionality is particularly valuable when organizing and analyzing data from different countries or sources, where numeral formatting conventions vary (for example, some regions use a comma as a decimal separator, while others use a period).

Function Syntax and Examples

The syntax is as follows:

  or (text_number, decimal_separator, grouping_separator) 

Where:

• text_number: The text-formatted number to be converted.
• decimal_separator: The character used to denote the decimal place, such as “,” or “.”.
• grouping_separator: The character used for grouping, like a thousand separator; for example, “.” or “,”.

Example usage:

 ("1.234,56", ",", ".") returns 1234.56. ("1,234.56", ".", ",") returns 1234.56 as well. 

Application Scenarios

Scenario 1: Salary Adjustment for International Employees

When a company makes payments to employees in different countries, it is necessary to adjust salary information according to local formats. For instance, if an Italian employee’s salary is specified as “2.500,00 €”, to convert this into a numeric format, you would perform the following conversion:

 ("2.500,00", ",", ".") equals 2500 

Scenario 2: Financial Reporting

In fields such as accounting and finance, there is often a need to consolidate numerical data in varying formats. Consider sales reports coming from different countries; using NUMBERVALUE or SAYIDEĞERİ can help transform these figures into an understandable format. For example:

 ("3.142,85", ",", ".") equals 3142.85 ("1,024.50", ".", ",") equals 1024.50 

This transformation allows the numbers in different formats to be standardized, making reporting and analysis processes more clear and error-free.

Daha fazla bilgi: https://support.microsoft.com/tr-tr/office/sayideğerİ-işlevi-1b05c8cf-2bfa-4437-af70-596c7ea7d879