string format
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
dear friends,
I have a litte thing, hope you can help me.
I want to convert a decimal to a string that have user-defined separator and
full decimal digits. If we set NumberDecimalDigits = num, we could not get
all deciaml digits if the length of them > num.
decimal string
123456.987654; ==> 123,456.987654;
123456.123 ==> 123,456.123;
.
Relevant Pages
- Re: VBA help to populate for every sheet in word document
... Dim num As String ... Graham Mayor - Word MVP ... Dim numBefore As String ... (microsoft.public.word.vba.general) - Re: Why wont this simple SQL statement INSERT a value?
... You can call .closeon a connection in .NET that is not even open without ... Dim num, value As String ... (microsoft.public.dotnet.languages.vb) - Re: VBA help to populate for every sheet in word document
... Dim num As String ... Word MVP web site http://word.mvps.org ... Dim numBefore As String ... (microsoft.public.word.vba.general) - Re: User Input issue
... Unless you terminate the string with a newline the output might not appear ... An int has to be at least of 16 ... just changing the data type of 'num' to double would not solve the ... covered strings yet (I'm a college freshman in a Programming I/Novice ... (comp.lang.c) - Re: Bitwise comparison question
... I like the use of Replace, looping a string of 0/1's would be faster than ... a bit numbered 'n' in a number named 'num' can in effect be set to ... Dim s As String ... really understand it without seeing a simple explanation. ... (microsoft.public.excel.programming) |
|