Error in JSON string while using WebHelpers.ConvertToJson()

[sssh]

I am trying to upload certain parameters to a web service from Excel macro as JSON. However when I use WebHelpers.ConvertToJson(RDict) function where RDict is a dictionary consisiting of Key, Value pairs, I am facing the following issues in the converted JSON string:
cm ³ is converted cm3, 90% is converted to 0.90. It would be great if any one could suggest a solution for this.

[timhall]

VBA-JSON does its conversions based on the underlying data type for the values and shouldn't actually convert values that are passed into it. That seems more like the difference between the Value that Excel stores for a cell and the formatted Text that is displayed. I'm not sure of you code, but here's an example:

' Cell(1, 1) = cm^3 (where ^ is superscript)
' Cell(1, 2) = 90%

Dim RDict As New Dictionary
RDict.Add "units",  Cells(1, 1) ' = Cells(1, 1).Value
RDict.Add "percentage", Cells(1, 2) ' = Cells(1, 2).Value

Debug.Print WebHelpers.ConvertToJson(RDict)
' -> {"units":"cm3","percentage":0.9}

RDict("units") = Cells(1, 1).Text
RDict("percentage") = Cells(1, 2).Text

Debug.Print WebHelpers.ConvertToJson(RDict)
' -> {"units":"cm^3","percentage":"90%"}