I have an issue that when I enter the number 9,999,999,999,999,999 (sixteen 9's) into a data field it gets displayed as 1.0+E16. I need it to display as 9,999,999,999,999,999.
Even worse, when I try to edit the field it either converts it to 10,000,000,000,000,000 or it just stays as 1.0+E16 depending on the format I specify.
The only workaround I've found is to set the format on the data field to currency which maintains the exact value of 9,99... but then i get currency formatting which i don't want.
Is there a workaround for this or something I'm not doing right?
Thanks in advance
Who is online
Users browsing this forum: [Ccbot] and 2 guests