An imported column shows 1.234,50 as text. Its source uses a period to group thousands and a comma before the decimal fraction. Tell NUMBERVALUE both conventions explicitly.

Convert a copy of the imported text

Keep 1.234,50 and 25,50 in A2 and A3. Put this in B2 and fill down:

=NUMBERVALUE(A2,",",".")

The second argument is the decimal separator. The third is the grouping separator. The numeric results represent 1234.50 and 25.50, regardless of the sheet’s display format.

The import uses a period for thousands grouping and a comma for the decimal.

Illustrated input. Keep the raw text while converting in another column.

Use the sum to catch a magnitude error

Check =SUM(B2:B3) and expect 1260. If files with different conventions are mixed together, separate them by source first. A value like 1.234 can mean 1,234 or 1.234, so confirm the source convention before converting it.

The converted amounts add to 1260.

Illustrated magnitude check. Verify the decimal places as well as the total.

Microsoft’s Excel function reference