Exponential Numbers

alan_watt

Member
This is a multi-part message in MIME format.

------=_NextPart_000_0003_01C049B2.1082AE60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Has anyone out there done anything with exponential numbers?, i.e. can you
set up something that will take a number on the database like 0.0000001 and
convert it to display as 1.00e-7.

The only way I could see to do it is to split it into 2 fields, one is the
number part, e.g. 1.00 and the second a UDC which is the exponential bit,
e.g. E-7. Then the second description in the UDC holds the number, e.g. -7
as the divisor/multiplier. This is obviously messy so there must be someone
who has done something similar?

Cheers...

... Alan =8^)
__________________________________
Alan Watt
Jade Enterprise Solutions Ltd.
"Making Good Ideas Happen"
__________________________________
Tel/Fax: +44 (0)161 428 1288
Mobile: +44 (0)7970 255073
Email: alan.watt@jade.tm
URL: http://www.jade.tm
__________________________________


------=_NextPart_000_0003_01C049B2.1082AE60
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"

eJ8+IgkSAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCwAIABIAHgAAAAMAHQEB
A5AGAAAfAAAiAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAAFAAAAEV4cG9uZW50aWFsIE51bWJlcnMAAgFxAAEAAAAWAAAAAcBJsfaR+hyU1+cSQ+eAh4Z/
07ULOQAAAgEdDAEAAAAXAAAAU01UUDpBTEFOLldBVFRASkFERS5UTQAACwABDgAAAABAAAYOAMQA
57FJwAECAQoOAQAAABgAAAAAAAAAILNtPZfVAUO40BPbMpmIvsKAAAALAB8OAQAAAAIBCRABAAAA
DBsAAAgbAAA/LAAATFpGdcgnM8MDAAoAcmNwZzEyNXIyDGBjMQMwAQcLYG6RDhAwMzMPFmZlD5JP
AfcCpANjAgBjaArAc4RldALRcHJxMgAAkioKoW5vElAgMAHQhQHQNg+gMDUwNBQh8wHQFBA0fQdt
AoMAUAPU+xH/EwtiE+EUUBOyGPQU0PMHEwKDMjgWTxdfGGUUENUY+lQJcGIOcGgbUAXRZRoEORGO
MjMaYRuiIPEHbSBDRQKDFBAfHxRAcyBPIVV5ciHUDlARnTGuNhYxI58DgkcJ0Wsh1N8PwCWfJXEm
3wOCVAhwIdQzI2ElrTc3Kh8hVChIUx4ACXB3KSHUNSwvN78gPy5WBxABoA3gLzU2L7+uODMxMQ8D
gkIHQHQN4P8h1C1BGpwgGAcTIacabyNIfzhVJPUUUBp+Jog4VCgoNO8WPynoOFQrhjQlcTwNLTd7
OFQuyzQo0UFuN9wyWzT/I2E8DTRXOFQ16Q4wRC8gGf8d+SGmDjA2rynpS7orgwKRVQjmOwlvMFCP
ZQ4wNf9RulLRUo9TmVGkU8JSL1X//1W9VT9Tb1G/EGAaUFuKXKH/XF9daVGkXZJb/1/PX41fD/td
P2EEOQ5QZFRlsV3TZbD9W4M1AFAJw2cxXdNJ4AKC8HN0eWwHkB5AG1AAAPJxAyFsaQFABRABQAPw
sGRjdGwKsQBgcwqwR2pgGxBqom51bQIAYRBhdXRvAGBkanXjaJAFEGdodGnBCgFpkKUKAWkBkHAw
A7IyI2D/D1IB0EzxEBgI0AnAaiBuMzxucG6JcCAPkgMwc278ZXgbYAewBbAAwAJzExBcY3MPkAMw
bCBkbYBpOnYTgEQBEGvQNgAgUI0KwGEJwG2gaCBGAiFHaFNoIGlDZmktD5A4z20SdeNp3C7wZHIJ
UHeC8xrQd4J3NFrxGzBwMXLh/2rPa99s5nXjbYY+kgwBbk/zb19wb3NieUAJgAIgbcHPcXNoIHQA
bOF0LXSgA2EKOjTQb4JAU3ViagUFkHSCQERhdGU6/3T0MzB1f3aPd594r3m/es//e9xo4IlAC4AO
Em3BDDB8tD8OUH0/fk9/X4BvgXdSZftzYBsxIC7QiUAEkHT0LUD/hA+FH4Yvhz+ITghgalALgPZl
aMBzYGwBQIlPil+LZJYwm4AI0GIKsHQ4i/j/fRQPkG4VEFJuEY30E1AboPhvb2aOT49fkGecEJGA
eQtQeS90sJXgCxGR9XP/dPQ5MJLvk/+VD5YfiE+ZH/9733zvjX+fP6BPoV+iYoJi/4IEgzkfAGlf
am+oL2yPbZT9m8M5bd+r/60Prh+BBbbw+ERvY7QwCfAeYW2gckavpyNzFho1DAFjAEA3uoh/csKz
cJGxAiA4gWiABaBt2nATYkUAwAMQU2iiAdB9aFMyAFCyCrqgm3FogGH/wwOP8LSRAFDDQMPEss+z
3/+0721Pt4+4n7mvj/3B8HHV/S6wVx4ALzOMcrIPxP/GD3/HH8gvyT/KT8tfzGk0wEVeLcDyBgDR
sMAAdAhwZRdPsxMQUKB2AlEge1XUbmsTUHcV0X0Kob+xXHcxZaAT4NpUaCaAOH8gIAMwzzHZ8M9g
pdEBgG6/gsAAYAnwcxC74J5xeAtgqQJAb3kJ8FxxkHBo4P8AIAuQE1Bz0aXQz+AA4QIwcwJgAIBi
ZAwwE1EKsGM/ARAFsHPQAgFyAItCZVxKaAWwet0yZGcAwHJ2ZwuB4hBo4EM0QAFBZ5524tnhkdGw
qfE3MABQ8+Nh5FU5OCNg4qLhkNqw/+NT5iOC0N5AAHALMN0xaKDLv7AOUHYIkHdrC4BnIP/oAwTw
B0AQYQFADgCloh5Ad9FA6XUCEG/R4M/gofB0/9oAmGHcgusH0dAAwNEAz+D/nnHfsNHQ0UEJMtFw
mIACUP8HQAuQ7hECUehhzqDrEOkB+89gAmB37tMCUQAgCcDOoPncsHJr4LG9whtREvKDUEfAgN2h
c3E6XFyBkG+9dFFtdKADEAeQ8lBNDeDnA2C/4AGAIE8BIA3g4XBeXPQGD5PeIMDyLpAwdPNyU4/w
Y2sJwAhg3RDZkP2LMXAS8vcRC4BokPcCaMD/AYDCwfcg0RDS0PcC0aP4c8sG4N3BbfhzZmilwPmU
/njiNfrz2EEFsOFw+bIGwLX7WHn8CHf6xP4ga/pE7+9xDNAmcPcCevhzzrBf0N0ToDV1EfcxcXAg
i0G/sMZU58FoYnYgMU/CAMWkZkbOsHBIAcQwAj6+VgNPAtD1kAdQAZcyBT3+QgMBAcR1EPegz2AI
cujz9njpQwjleQll84Hx0ApXv/rBCnUbYQp1GJAIcncOQMNlsQiBaDM5Nh8ADPLcZ2/vMBQQCXRo
DlKMgP8UMObwv7DpkAMBUVEDEO0w9mej8OTANiaQJpAUIPYDBQMBdc9AIDlhNDcCMdFANzNjOGU2
l5IQkhAN0DUSIGQ4MMBiY2WgYmM12kAykG4FNpA4zRD/2P/gAAAQSkZJRgABAggBAGAVoQD/7QYc
PFDhkNEQ5hFwIDMALjAAOEJJTQP27RXgF4EQFcIVYBghF/V1FyPzF4MIF4MXgRciBO4KF4MVkBcT
JxfQF4IacCsa0ReDAhcj9ReDSADWL/SQGCFsHUEGGoUdNKihmZodxzIYA1oXgbUd1jUYAy0f6Bcj
+BeDznAV4SKPItID6BeCIt//I58kryW/JswaIxmUG1Ia0SwCQCpkGgUJF4IEy1kapACAF4EV0QEs
UZDxK5KvABgVYBTNHRAdENEV8P4AJ/LyIP4g0qDfg1ABEPygOECQMGLyEBZHCKggNBbx/+4ADhkw
IwBkLFItkNsAhAgADAgy0AkIDAkACQwRCwoLERUADwwMDxUYExPyFTQgGBEz0DSSNIU1XwE0kwEN
CwsNDg0gEA4OEBQ3QA4UdzdyN6A0hBE0jzmfM9D/GMAAERmQFbCAAwEiIhxAEQEDO7D/3UMrsBmA
/8QBPxgRBRYBPOMZpQMVYQQFBj4HMvAzgBgxPNwVkAIDMz32F9ABBDvAPeACBYAHBggFAwwzP4EC
ET+wIRIxBUFRAGETInGBMgYUAJGhsUIjJBVSAMFiMzRygtFDgAclklPw4fFyoAA1FqKygyZEkwBU
ZEXCo3Q2FwDSVeJl8rOEwwDTdePzRieUpACFtJXE1OT0pQC1xdXl9VZmdgCGlqa2xtbm9gA3R1dn
d4eXp8C3x9fn9xEcQBWATT3gBD+zQOAFNUFTIQgxEgRB8XEiEwUQMoGRFEKiwVLRIPAzJGLhQ1CS
Q4RTFXKgNPElBkQyIAcmNcLSRIGjF+lEsFU2g1DiRWdGD0cX8idHqP/aMrA7YEFiSHABPJD0sNMx
3TisAKK3lThG1ggEAEK1MNhSJA5UAE2N+KFrqAXSAEg4FOkpiUx1AE5ITEhFDA1jAOCj6XmpylKS
ADRTWhuimIQ5AEpSVaWQmLgoAEpJUm13ElDLAFymkkgi3//QAPUW8hTJgSmAANUn/RKSBsjcAOLg
Z+5RT9lEgJ7pIJXDoMpYQAASEElO1wjUogCLZkpKJeAobgAyYOhSRaRJDgBOh7hKTz48pACrSJ0M
SNEi5wQIkltgJ1FrjMEA44lTbDhISSsAJKUJQkqn/9EA9UhI6iDwkoMAvIwUkI3aGFAAJ0T2l0a/
IhAAHOcdDoisJZEAeOyZridOQocAPCkyZSWs04QAh8FINBSSsB4ACkAnAPxTxKQAuAWjxUXjgKcA
qEz9QO3kgqkgGJ+CIyxMcIJ1AFDjX705GqSmAMiHCRwU8IFLAuBb0LBWElwf/wDS9UPCC46yjADu
Cq5MohbJZwBB5Q3CNDqppwBFjQFnhonY1wAHQp7CBqU4HAB3QVSgCpAFOEAJSgvpUlJVgJIAm+KS
rZ7vmmcAgEfBR0UoMaEAhJVsPxCQ4+CAm1+KaSNfBGAgAL+kj1k8eCBWAFsnXngI1fJRAWPR0/U7
DDVXHACrDxIVfgohZAD3U4QUgiABwgAKXpoo4VgFLwBPvwnaIUkFwAAhTFEe5sQPwQgF8/kxEKim
UHYA4cym3OHdJakAAVIEqDXA/HsAhTCSQs9p5Hwg1CCUYJDUoI1SAFzGqsPBBHw+AArDWhogJNaA
ANGnCkkl/9T1BAe+O6B0py6QVAATgxSKRhRQZQABqK1ArolmogDm/u/cpJJLkACmPwRXNB17oQA4
EchBaWDgCQDXXyUC3TQyfAARCmKKGLGO3gA48yiAGAfHhACqadxMx8EYJACQGAYdR4aojCPRUGvQ
6C5RU4FKG8Ccigl//9kaFB3UfgcrsD0hPSEu7y//MQgh1zG1GpM9sBBAkAMd1BmlXTJzBkjQPfB4
4AU+AAkjSVB/gAsIBkDwCwzmCjOAgFAMEDikgLWBjxM2dEkwBw1UEBgQEF4YN384j4W/OqLCOvKW
HADIO2BIcTu0xACO3z2RPRgakz+gK7AIPOuJNn4EF9BIkUCwi6E9sD8lERk/oBAgQbDk0EATUMAy
QSJgIwRIcDvAD43AQLA8wT8mESEQMRRBIEIAMEqQAnESgkBCoMEiQtESijsfLCJQdBVwUPIV4PTX
kwBGsPqU0fcaiAEZgBLOJyKEva0AY+hrCwmLPKcAhTauxDqMGsBAMCFgS4EATJAQBNCBLXCG0puN
WABRJDK9YELAgRAoBGMalMAEJqwAYr0hqcQkBisAK4uaIEAxjGAAmMaiExq1V3MAVzZgBCxotNYB
lJAgBWCENYITSFYw2pJwTmmYMAhAXNpK4hNBkqADAFhStWtaiYyUANDSnNmJAzZ5QCwQmMGsNZkA
swCeHSlvXquY1ADVhYjlDJMowgBmGrLqNNTGsADRrEJBRHO3WgB6JgRHKWXNhAChJANXRa1NWgCa
xrdZjVDMxgABWu7WialyjwA6sc2ZGEgIawCm1tDY9GsGsAAqGZjVjR2btwC3E8I8qsLEhARAItyg
tYaNA0YAojVOSYKYx1VAtrXqPOx5PDCRIDWGn1G0ldAKYADWpSSEFWL23gDXrn42eCxghgCGgsOo
aECFjQQoDaIgQRRSlXsAezVY5eFTNawATIj6PsdREUUAhchKAGGsOikAFAX1e/VY0csAxs8W3SCB
DaMI6lNFG0DMhkIUAGKWtYdGoGOvgFXMCJYvPyWT4ADjUAmpCOYsJABDJYBSr6Gm0QCqhe3AJ4se
ZADNNluimoaIhAAkELAhJVSUNYB0WtqPTVe3PeAgR52WKsNTYCu4QNoxhCGYkHygKKAauu06j5JA
IefwANjzLKIaqblNSJ9xjDtwGZOV4DEAWr6r2NWrQkLYYs8vUHGJ0AI8sZiQgIFUSF40trYRIACd
RVIIIII8UiBJJI3sjWTQJ8ECPloQ7JJJJ+AtANJPwkPZJPwIANr0nWSfBHjZADpPhjZG9jGxCO1a
QbSAVsY2PwCItbb4+AtLvQDwLyrRaXFtggA3zotq1ZYQ1gCoSI8y2WWiHQBIEhbGSTvggQBstotI
I1nRkQCxeGRskTF4HgKQdzBJHohMW18AgQtjZOj0QhZ0573vQBmw0z2xsVD8ALz/AIzOyfyEIPyl
+OfgdQB+OQB8GfykfJXyVwaHsNM+cgDkgVWKCIVqVbngH6tjTAC2Kx9dxYbMrYI6TjCkodi1ixEg
BONT5vAWNCojogGO0DWrWzjTsdgA7ncdtYQ610oALjT7KjzormmAckkobRKG1rNgAD4qfqXypPI2
AOylEmLIx2HYAGydy2LZBX9bALivt25Yyea2AJq3pKmUKybdANJ2vWr7VhOsACsnpG2Besv6CA3z
Z25gmzHZKgC7cfbUtZu02ABtsbdhKRe4cYBXJXJbt2XaskEABerqavgfpskAL3itMqa7WQ8AkhxA
myIcQ4kAP45rZXsnXIoIa2rZcKAQNpKUAGao2WslW92OBM2V2bARyhNCRAAdWhQJDTiynQAfvFmv
jeK/egGaADL05tfKldsAq73dlEqGirsAdkxQdRVE2hQINOpyU5BqLNQ4Apq7YBgs65K2VgBaXcDt
y2Xo0ADxVY62q0yjUgCgSQuBEECtowAs7Jpyq8MrLQDjt1czplH7bIC1VYvVKzrIz7AAn1/7FUVT
qjoAo5O1juKyRMkClVOAOzQ2UT7GIBb6GV8tVmCRegDe1nWyGm0oEQAjbHZn9mQQQQCTul2sdk1W
0ADwqzuzD+hmfACh+9Eh4m7dWiAS1e1FkxHgobQAOGY/ts8eS9oA2OrrV+sjl1+Ad68aVQkfWllg
AFavgcDfLY2zCJE2cupgx9jk6gDP+SrdqY610QCZK8r3XlWxigCNCRVCOlZzKQC2RqtXks273AD7
borlkgkWjwQVWJ1AGPHRU0YAzIpPTpYTIR0AT0fZSb5WNpkAasn10Mi/tAwaxbiwITMAYRBmSSMA
sXycu0lWVYkG6Jqg0MBobY5JPwCtR4qt9LO+LABZPuVLO6q26yCNu1cTZZpw6NiA7DsX/YRRi8+A
AKxarqckSNIaAEODA79klNKpAAkkIY2NjscjBPYiZMDLx1sqaAT04LtgniUL1raYkcluUGKxAQIG
PJA+bbtguqTl2jzg5eHqbAChWoAOjFvyLQCn2ePrdQFMKAD8MUYSU5zdTQAY+SfwwiafIQBNxSEC
781bKwCURkIA5yg+UwC8J3UY6ARh6QD6J/NZ9uydSgFLUN4Q9ncr7ZQI5ui/pxCafUmcAJQJsI7I
euTOELIC2ahywIaTlAhan7qT0N06dfsoJspx00Dyo+BfOgDcfBo5hkR2WwjwntxFoCuKR4QA1imU
XwttwuQBjxAgP8oE3OknINSyYh1/8HCAuQAJxlBuykVi6gJrYFBjBXGU9HQACMfynGpzI3UEELjN
kNdAGeNUACY+acovKZNgANkQgBlcG+qUgMBDLdlsgMexwCKZgJBRwGVYoMU/AJTDe9J1kgfCAGJk
XVpxSytWAuzEQEKDG1LdkwB/kpxAFz8L5QA7X6BIymPSYQD605UQUD6uCAC7f8Te3q3NkwAb6HGl
ymCnoQB0+U1C8OzHyhB876WUwZAlDAUAF1GFeyu/KY0C3qeAbK5W69Q2IMelZwmd8ZA0bABRuU/l
ThfU9iA0jzUvYU6w86IQygJ3REFA/pACAMDJX1ElMLr6APnsvbhRm/VdAKcJjpuo9fs3CGpCfbtg
AL2RY3E0EKTv0XhwAjAG73AITmFtBlVDOlwnSDVjUAyQZ3ICYCAFeiJzAxJDb21tbxsBsAPXTQxg
DJBzb2YAdCBTaGFyZWQlAxJTEIB0aQSgZXImeQMSAlB0dQYwIELSawOAZC4PsGcBLxAQ1EZsEJBz
ApQyCIp6IXV6QGQClDEIiRAABwBXqRHwdGgClDAIikwMwUMNT3rgV01vZAKFOREIikJhYwgBb3Vu
EwuPDkJheRHAdEluPENlCVASBwERAZBlYxB0ZCBcDLJ4MFwYaGVhEBAHIDcwOBhcZm8woBXlY29s
zHN4FhJ6wGRuFaAGMBpcCGBi2bAFkHB0M5+u4BTCDLIDgA0AMzYVgAEUw2VmYXVsdGPUbCABgCoY
EG4UwdTw1GwxGvF1BYBtGvIGsBxydBuCDMAQEG50N84yFYAbAAYQbmcBgBsA5HR4BrAgLgiCGuiu
4DsbohpwchwPHR8eL2wzOxrxEBBjH98g7yH/bDRfGvG6cB+vJG8ldCkebDXHIy8oDyVFYiAoCJEp
P30bMzYm3yufLK8tvxtRN/8vAxvvMH8xjx5sFjAvHzSf9zWvNr8bYDkzjzkfOi87NXcYEAYgBlBw
CcAMwBUQcd8aoBUhFYB6gBWAdw0AGQHpQCFcYQFgYUHwBhBCMn8bsDzQGkAaUHuwQjB3cHWjPRB6
gGdodEFRbhWARwyxFYB6kGFwMBUQZrxzMibACcAlICiANTNwwUXSZmUxMDMjEHAg8xlxRcNucEYZ
R7BGwhqxM0vgKIFmMhYxSSJjZtAxNyBIQkAgJRATULUHACATYSANIBfhIHswb0rBSoENIAzAZ3pg
epBoWiAVYHAG8T3gaUJwILtDAXtQcgnySR9KID9N/wFJ8ywgaS5lLiBqYyUQIBNRIBTABeB1/nBR
oARwUcBMI0swBsBMYbsJUEsgYcmASnBNdSBPb59J8wShSzFLgAbAYWJCQN97YFRPSfMMsFOBMHxA
WHPOMUpxFQAXAG52BxAF4Ot6kEsgb0uAaQFgCcB7APdKUVavSfMxWGECglr/SiCcLTceUFyPSgIN
CkAS/1qwQBNAz0HfQu9D/0UFXh+tXylUVeEEoGx7AHdaYf5JWSEaYBUAFMB7YFniWfD/WbFaIFnS
WjFoklmRPeBZ8OYyAcETwGRzUMBKsmjCt1XhU9VAIXRQwFEAZ1EQf1wiWONV0hTBBKAVAD/AVexE
Q3pgTCBjTKBq5UzK9mJ6kGwFRV3QXg9J81EQ72ahVbRtRRAQcwWAAjAG0v9poVXDbdJ7kGpRawls
BReCn2GwTKBKIEpRVdNpdlog8G9yL20aYQIwDLAHEP9d/0nkZpFowWjBfNB3ABHA5nNnAQJwc3Nn
UAWwSyX/d2A9EA/AbSFSMUqybhBZ8I8GEEpgS5NSKHNpbQPgbWGAP19lX2VDFaBNwYX/eB9fG3/v
Xy9AZkWQruBgX/9hb2J/Y49FL0Y/R09IWmoj/xZAZ8AGQIjAGsKNIQzAe7EDjKF4rEFVVE9URcBY
VExJU1SJEAGQtCAicEBtQJCEoFOH0PpuB5MigZAIkY0hTdAacH9k0koBiXNIoIlVilKJUW7/GIAF
kAXAHkCUkI9QiYF5YNA9OF4pfoVfle+W/q9+hZhvmOWU01cGwHSYD/5KFcFwMD3gBxCUMFogdABe
UxcQE3AG4UpgTBTwLrGajyCTTVNwTDJHFmCdFQBJEBBKUUpAcHByEC6UlX+hP5ecVBPAL0aIYXg6
mOErNDQ/IMgwKTGx8CA0SXAL4P1JcDh+hQ/wb6ALYAMAVjEZo7g3ORYQClA1NTD0NzN+hUWQoqXm
hiAlECYuZzCaYEBqFcEudGJtfoVVUkyl5ofwdOBwOi8vd6tgCECpe9+hv62PgaKCz0BsNKdAhQP4
c2I3KpCFX4Zvh38MwP+w0ojPid+K70hJP/+wn7Gv/7K/s8+037Xvtv+4D4yvjb8heOhJTkNMbdBF
UOhJQ1SqQEV5YJAwFQD+IgLxxtEDXMbRBGvG0QVvH8bRBqnG0SUQVkBucjJZbDBpZpGAkDAqpXBF
AFJHRUZPUk1B+lTFYEWQEJGsSWwBE4IvCV+TfQDQ4AsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOF
AAAAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADABqACCAGAAAAAADAAAAAAAAA
RgAAAAABhQAAAAAAAAMARoAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAAB9bgEACwBTgAggBgAAAAAA
wAAAAAAAAEYAAAAADoUAAAAAAAADAFWACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAVoAI
IAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgB6gAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEA
AAAEAAAAOS4wAAsAe4AIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAACwCCgAggBgAAAAAAwAAA
AAAAAEYAAAAAgoUAAAEAAAACAfgPAQAAABAAAAAgs209l9UBQ7jQE9symYi+AgH6DwEAAAAQAAAA
ILNtPZfVAUO40BPbMpmIvgIB+w8BAAAAowAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABQU1RQUlgu
RExMAAAAAAAAAABOSVRB+b+4AQCqADfZbgAAAEM6XERvY3VtZW50cyBhbmQgU2V0dGluZ3NcQWRt
aW5pc3RyYXRvci5BSldcTG9jYWwgU2V0dGluZ3NcQXBwbGljYXRpb24gRGF0YVxNaWNyb3NvZnRc
T3V0bG9va1xvdXRsb29rLnBzdAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAAMQAAADxBQkVETElO
QURER0lGUEtFQlBHTEVFTkJDQkFBLmFsYW4ud2F0dEBqYWRlLnRtPgAAAAADAAYQ1Z/dqAMABxA1
AgAAAwAQEAAAAAADABEQIgAAAB4ACBABAAAAZQAAAEhBU0FOWU9ORU9VVFRIRVJFRE9ORUFOWVRI
SU5HV0lUSEVYUE9ORU5USUFMTlVNQkVSUz8sSUVDQU5ZT1VTRVRVUFNPTUVUSElOR1RIQVRXSUxM
VEFLRUFOVU1CRVJPTlRIRUQAAAAAiLE=

------=_NextPart_000_0003_01C049B2.1082AE60--
 

Zoltan_Gyimesi

Legendary Poster
Alan,
(first, what is the crazy list on the end your original message?)

Let's see. I have never handled exponential number even so I have some coins.

If displaying exponential format is your problem only but storage then you can write your own Display Rule business function (C or NER) to accomplish this.
* You can attach this BSFN to the data item as Display Rule in the Data Dictionary
OR
* You can override Display Rule of Data Items with this BSFN on the Data Item Properties sheet in FDA and RDA.
OR
* You can call it directly from ER to generate your formatted number.

I hope, could help a bit.
Zoltán
 
Top