Excel to XML: Need some help fine tuning a macro
 

Hey all,
I've downloaded a Macro http://meadinkent.co.uk/ and have been editing
it get the exported XML to appear as required, however I can't seem to
get the 2 of my fields to display correctly.

There are two fields which have numbers in but are formatted as text
because I do not want them rounded up.

One cell has -0.08162498 in it and in the exported XML doesn't even
appear.
Another cell has 51.51891794 in it and in the exported XML appears as
52.

My question is how can I get the information to appear as I've typed
it in rather then rounding it?

I have changed the 'Function FormChk(RowNum As Integer, ColNum As
Integer)' to have more # in the length of the value but it doesn't
work, I believe this could be because the cells are not formatted as a
number.

Macro code: http://meadinkent.co.uk/myxml/XL_to_XML.txt

Gary