How to Change International Number Format in Excel (4 Examples)

Steps:

=NUMBERVALUE(B5,",",".")

How to Change International Number Format in Excel by Using NUMBERVALUE Function

Press the Enter key and use the AutoFill tool to apply the formula to the rest of the cells.

From the Format Cells dialog box, select Number from the Category list and check Use 1000 Separator().
Click OK.

Steps:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FIXED(B5,2,FALSE),".","$"),",","."),"$",",")

Formula Breakdown

FIXED(B5,2,FALSE) takes the value from B5 and returns the value up to two decimals without any commas.
(SUBSTITUTE(FIXED(B5,2,FALSE),”.”,”$”) function takes the output of the previous function as the main text to replace and replaces every point (.) with a $ sign.
(SUBSTITUTE(FIXED(B5,2,FALSE),”.”,”$”),”,”,”.”) function takes the output and returns after replacing every comma with a dot.
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(FIXED(B5,2,FALSE),”.”,”$”),”,”,”.”),”$”,”,”) function replaces every $ sign with a comma and returns the final output.

Sample Dataset to Change International Currency Format in Excel

Steps:

In the Format Cells dialog box, select Currency from the Category options and select Euro from the Symbol options.

Format Cells Dialog Box to Change International Number Format in Excel

Dataset to International Date Format in Excel

Steps:

Select Number from the Format Cells box.
Select Date from the Category and Location to German(Germany) to get a European format.