Convert scientific numbers

HL

Hello, I would like to convert numbers in scientific fromat (1,5E7 for example) in a number format (1 500 000,00). Does someone know how to do that ?

Thank you !

Turribeach

Where exactly do you want to convert this scientific number? Is this a data type issue or a display issue? Can you post a sample screen shot of the dataset column value?

HL

Turribeach

Jul 31, 2024

Where exactly do you want to convert this scientific number? Is this a data type issue or a display issue? Can you post a sample screen shot of the dataset column value?

Here is an example of a number I want to convert in French format

Turribeach

The first problem that you have is that is not a number, it's a string as shown in your screen shot. Someone has locked the meaning as well, which is not usually required (read more about storage types and meanings here). So as a first step convert your string into a number. The use the convert number format processor in a Prepare recipe to change the format.