I have the number 0.5, I would like to turn it into the string 0.500.
Or more broadly, I have some function which returns a value ( in this case exactly 0.5), but I want to turn the number into a string and extend the "visible" accuracy to three decimal places.
For example,
Now, Range("R8") displays "0.5 0.5" and not "0.500 0.500" which is what I want to display.
Please Login or Register to view this content.
You need to format the number
Range("R8").NumberFormat = "0.000"
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
That does not seem to do it for me.
I've also tried using the round function to no avail.
Maybe:
Please Login or Register to view this content.
Last edited by JOHN H. DAVIS; 04-21-2016 at 09:13 AM.
Thanks JOHN, that works great.
How does it work?
You're welcome glad to help out. The format function tells it which format to use and the apostrophe returns the number as text. "'" & Format(YOURCELL VALUE, "0.000"). Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks