I'm not sure I've understood the question, but, to display the result of a calc involving long numbers, format the field as decimal to stop it displaying in the "1.0e+9" format.
Thanks for the tip. It sounded like it just might work, however it wasn't to be. The display shows 1,000,000,000, but when you click in the field it still says 1.0e+9 and I can't therefore use it in my text calculation.
I think that it might have something to do with how the system holds numbers and I have no idea how to change it.
There is a function (having wrong name)
The function is now GetAsNumber( ).
No, it is a function convert Text To Number.
NumToText is now GetAsText,
NumToJText is another fuction, convert number to text with formatting.
Sorry; missed the "J" (number to Japanese text).
But what does that have to do with displaying a number correctly in English?
It is the reason I wrote "wrong name".
Using NumToJText(p1;p2;p3) with p2=0 (no separator) or p2=1 (3 digit separator)
and p3=0 (use num chars in ascii),
nothing is Japanese. Useful for WorldWide users.
Again, thanks for the tip. Now the calculation is converted to text I have 1.0e+9 sitting in the field. I'm thinking that to save a whole lot of extra time and effort my best solution might be to use the case function either before or after the calculation. I'll have a play.
I appreciate that you were able to work that out. I would never have thought of it.
I seem to be missing the point on this thread.
Why can't you use that field in a calculation?
Surely 1.0e+9 is EXACTLY the same as 100000000???? And the formattign we apply with the Inspector is just that. Formatting the number to some rules like $ 1,000.... or £ 1 000....
Or are you looking to concatenate this number with some text - as is
"You owe me $1,000,000,000 please pay now" but formatted with thousand seperators.
I have to report all my information to government in a data file. The structure of the file gives the specifications for a data string for each record.
I needed to have the number in alphanumeric form, with a width of 10, in a certain position in the data string in the correct format.
I hope that that answers your question.