LinkBack URL
About LinkBacks
Hi guys,
I need some help adding a line to my Function that will Format the numeric field as follows: "#,##0.00"
My function code:
Thank you!
Please Login or Register to view this content.
Hi guys,
I need some help adding a line to my Function that will Format the numeric field as follows: "#,##0.00"
My function code:
Thank you!Please Login or Register to view this content.
Last edited by onmyway; 01-30-2015 at 11:53 AM.
A function cannot affect the formatting of cells.
oh
I have about ten fields i would like to format in that way, any idea as to what I can use?
I don't get this anyway because your formula returns a boolean, not a number?
To clarify, you can format the number returned by a function. I just tried that. But why not just format the cells separately?
Last edited by StephenR; 01-30-2015 at 11:39 AM.
Hi Stephen,
Something like this, but for each TextBox?:
Please Login or Register to view this content.
Have you tried that? I don't see why that wouldn't work. To do for lots of textboxes you would need a class module, but unfortunately I don't think that's possible for the Exit event.
Last edited by StephenR; 01-30-2015 at 11:54 AM.
It does work. Was hoping i could have something more elegant. like a function.
Thanks for the help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks