Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Excel number format in Dataiku

Level 2
Excel number format in Dataiku

We have a column that contains data in 52,136,999.976 format in Excel. When exported to Dataiku, data becomes, 5.2136999976E7. How can I represent this value in 52136999.976 math number format (without commas).


0 Kudos
1 Reply

Hi @pi_485 

By default, DSS will display numbers in the scientific notation above a certain threshold and this is not configurable. However, you should be able to remove the scientific notation for numbers by using the format() function in a formula via a prepare recipe as described here:
Hope you will find this useful.