Hello developer, I encountered an issue while using VBA-JSON-parser. On one of my computers, during certain calculations, for example, 1/2 is displayed as .5 (without 0). This leads to errors when using the MID function for data processing, causing the final result to be off by approximately 1000 times the actual value.
How can we avoid this situation, given that it involves many users and it's not convenient to modify the settings on their computers?
Hello developer, I encountered an issue while using VBA-JSON-parser. On one of my computers, during certain calculations, for example, 1/2 is displayed as .5 (without 0). This leads to errors when using the MID function for data processing, causing the final result to be off by approximately 1000 times the actual value. How can we avoid this situation, given that it involves many users and it's not convenient to modify the settings on their computers?
https://github.com/omegastripes/VBA-JSON-parser/blob/0199cc8e458302619e0f3338f260f2e3cefeef04/JSON.bas#L74
https://github.com/omegastripes/VBA-JSON-parser/blob/0199cc8e458302619e0f3338f260f2e3cefeef04/JSON.bas#L174
The example image was sent incorrectly, please send it again:
thank!