Format Number in formula

Hey there,
is it possible to format numbers inside the formula?
Thanks for any replies.

Yes. here is the example.
Some more examples: https://www.google.com/search?newwin...30.BMYmSIZ-xK8

Hmm jeah i read the same but I will lose the integer, i mean number type. Can I return it to number after the formatting? Kinda ToNumber (ToText ())? Without losing the formatting?

Sorry, I couldn't get you...
Number is just number. And format it somehow is just a way to show/display it as a text. After you have formatted a number it has not to change its value.

I use the field in a function and its type is number. If I make totext(field) it wont be recognized as a number type and shows me an error. So can I convert it back After formatting like tonumber(totext(field)0,"")

Quote:

---

Originally Posted by Sam85

I use the field in a function and its type is number. If I make totext(field) it wont be recognized as a number type and shows me an error. So can I convert it back After formatting like tonumber(totext(field)0,"")

---

And what this function is supposed to do?
Do you use it within your formula or somewhere else?

Yes. I use will use the formula like that:

intfield = Formula = tonumber (totext (field),0,""))
In my function

Function check (field as number) as Boolean
'Some code with field = intfield
End function

Or shall i just change the type in the function to string?

Well, have a look at https://apps.support.sap.com/sap/sup...lic/en/1213922

Thank you, sir, for this link. It is helpful for me.