Filling with zeros for two decimals places

perlfan

Registered User.
Local time
Today, 12:10
Joined
May 26, 2009
Messages
192
Hi! I need help: I'm passing a few numbers on to Word and these should always appear with two decimal places, also if it's a whole number etc.
e.g.: 10 -> 10,00 or 9,8 -> 9,80
Depending on the regional settings, the decimal marker can be . or ,
Thank you for any tips! Frank
 
How do you pass the data to Word?

Maybe you could use Format(strData, "#.00")
 
I already tried your format() suggestion, but the problem was that if the variable was zero the output was ,00 Maybe there is a way to solve this? Btw: the values are passed on in a temporary txt file and then inserted into bookmarks. Regards, frank
 
0.00 - this is what I needed! Thanks a lot!!! FRANK
 

Users who are viewing this thread

Back
Top Bottom