Unable to change class interval value in smbology

Question

I encounter an unexpected problem when manually changing interval values in a graduated color symbology with a number of interval classes. I can only change them to integer values. If I try to add decimal value, eg 11.5 this is not accepted, and a message says "Upper value. Value '11.5' could not be converted.". (If I try with 11,5 the message is "Upper value. The input value '11,5' is not in decimal format."). The field is double, with decimal values automatically assigned when letting Arcgis decide class boundaries, eg with natural breaks. But I cannot change to another decimal value (but can change to integer value).

Using ArcGIS Pro 3.6.1

JonM32 · Answer

Glad you found a work around!

JakobWalve · Answer

(See my first reply) I just found out a way to get around this bug. In the Histogram view I can change to decimal values.... This updates correctly and shows the updated decimal value in the Classes view. But in Classes view I still cannot change to decimal values.

JakobWalve · Answer

Thanks for the reply. If I try another layer (a raster layer) I can change to decimal values.

However, the layers not working are all linked Excel-tables ,joined with a map-layer. Works nicely to join and create symbology from excelfile fields with decimal values using natural breaks or other method, but when changing to manual and modifying values manually it will not accept changing to another decimal value. But accepts changing to integer. It is within the range. It did not help with excelfile formatted as number (rather than general).