0
Answered

Format Number tool giving error on valid numbers!

Kyle TFL 3 years ago in Server / Execution • updated by Gandalf 3 years ago 3

Hi

Im passing a recordset of numbers into the Format Number tool and I keep getting an error in the debug: One of the identified items was in an invalid format.

Everything works until I start passing in decimal numbers, regardless of if I try and round them or not.

I have checked my computer regional settings and they are correct for the numbers I am using e.g. 200.0876 and regional settings says use a full stop . for Decimal Symbol.

I dont know what else to do, please help.


tool execution workflow
Under review

Hi Kyle


You are on the right track, that error is from the system not understanding the format of the number ie. its set to comma and you are using full stop or vice versa.


Unless you have manually changed it, the Warewolf Server will be running on the SYSTEM account and not on your account. Where did you check the regional settings?


For Instructions on how to change the regional settings of the system account to be the same as your logged in account, read this Microsoft Topic:

http://windows.microsoft.com/en-us/windows/apply-regional-language-settings-reserved-accounts#1TC=windows-7


Please test and let us know if this resolved your issue.