Avoid scientific values

Tej_04
New Contributor

I am trying to insert data into catalog tables on data bricks but the values are being displayed in scientific notation which i am trying to avoid how do I view the data in standard format

for example - 0.0000000 is being displayed as 0E-7