InfoPath Dev

 This is really probably a daft question, but why would a numeric field with no decimal places in a SharePoint list (read from data connection) import into a form with many numerical places?

 So this in the list : 4

 Becomes this in InfoPath 2007 : 4.00000000000000

 In infopath the field is simply a text field, which is fine as I'm concatenating it with other information.

 Bizarre weirdness going on somewhere....

Actually, SharePoint stores the data as a decimal type. There are display options in a view to allow you to not display the decimals, but they are there.... And InfoPath is just brining back the data.

So - generally, if the decimals are making a mess for me, I use substring-before to get rid of everything before the "." if I am using the data to set another field's value....

Hilary,

 Many thanks - I've used substring before, but I'm not actively creating forms every hour of the given day to remember all the permutations possible in InfoPath - so thanks for refreshing mind - an explanation to my old age maybe?! ;o)

Jason.