Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on July 31, 2024 8:18AM
Likes: 0
Replies: 3
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 !
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
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.