-
July 16th, 2019, 03:47 PM
#1
Format Number in formula
Hey there,
is it possible to format numbers inside the formula?
Thanks for any replies.
-
July 17th, 2019, 01:58 AM
#2
Re: Format Number in formula
Victor Nijegorodov
-
July 17th, 2019, 10:18 AM
#3
Re: Format Number in formula
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?
-
July 17th, 2019, 10:27 AM
#4
Re: Format Number in formula
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.
Victor Nijegorodov
-
July 17th, 2019, 01:32 PM
#5
Re: Format Number in formula
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,"")
-
July 17th, 2019, 01:45 PM
#6
Re: Format Number in formula
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?
Victor Nijegorodov
-
July 17th, 2019, 01:51 PM
#7
Re: Format Number in formula
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?
-
July 17th, 2019, 02:19 PM
#8
Re: Format Number in formula
Victor Nijegorodov
-
July 25th, 2019, 03:18 AM
#9
Re: Format Number in formula
Thank you, sir, for this link. It is helpful for me.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|