Changing attribute table values to scientific notation

323
6
Jump to solution
06-30-2021 11:42 AM
BeckB
by
New Contributor III

I have an attribute table that I would like to format. I need to display the numerical values in scientific notation (ie 2.367E-02 instead of 0.02367). How can I do this, especially for multiple fields at once, in ArcGIS Pro version 2.7?

0 Kudos
1 Solution

Accepted Solutions
KoryKramer
Community Moderator

Have you looked at https://pro.arcgis.com/en/pro-app/latest/help/data/tables/format-numeric-and-date-fields.htm ?

That shows how to format a field to scientific notation.

As for doing multiple fields at once, that is not currently possible.  I'd recommend going to https://community.esri.com/t5/arcgis-pro-ideas/copy-number-formats-across-multiple-fields-in-fields-... and adding your support by giving a kudo.

Hope this helps!

View solution in original post

6 Replies
KoryKramer
Community Moderator

Have you looked at https://pro.arcgis.com/en/pro-app/latest/help/data/tables/format-numeric-and-date-fields.htm ?

That shows how to format a field to scientific notation.

As for doing multiple fields at once, that is not currently possible.  I'd recommend going to https://community.esri.com/t5/arcgis-pro-ideas/copy-number-formats-across-multiple-fields-in-fields-... and adding your support by giving a kudo.

Hope this helps!

View solution in original post

BeckB
by
New Contributor III

Thank you so much!  I appreciate your help.

KoryKramer
Community Moderator

No worries.  Glad I could help.  Please mark the response as an accepted solution to help other community members.

Cheers

0 Kudos
BeckB
by
New Contributor III

I've encountered an issue where the scientific notation formatting isn't carried over when I export the table. Should I create another post for this?

0 Kudos
KoryKramer
Community Moderator

To maintain layer properties, try exporting either a layer file or a layer package (depending on whether you can reference the original data [layer file] or need to include the data with the layer [layer package]).

https://pro.arcgis.com/en/pro-app/latest/help/sharing/overview/save-a-layer-file.htm

 

BeckB
by
New Contributor III

I have an attribute table that I would like to format. I need to display the numerical values in scientific notation (ie 2.367E-02 instead of 0.02367). How can I do this, especially for multiple fields at once, in ArcGIS Pro version 2.7?

0 Kudos