WebGrid V4.8, file version v2.0.2.2002.
I need to be able to display and enter values (no negative values allowed in my case) with up to 4 decimal places; I tried ##,##0.0000 for custom format and #,##0.0000 for regex validation with Number validation type, and "General" NumberType. This causes validation errors; I then removed RegEx value, this removes validation errors, but then when I attempt editing, my 4 decimal place values (which are for the most part 2 decimals followed by 2 zeros, e.g. "58.5300", turn into "58.5299987792969" when cell is edited. I can still enter values with up to 4 decimal places, but this is confusing to the users, as well as overflowing my cell width. What validation/number types/regex/custom formats should I be using? The underlying data type is a double... Ideally, I'd like to display numbers with a $ currency sign in front, removing the dollar sign when entering editing mode...