Hi,

I know there must be some way of doing this, but we are 4 guys, 3 of which have IT-jobs, and none of us can figure out how to format numbers/decimals. (or any other type, but numbers give us the most problems).

 When we get to a new row, if we type 5,4 it format is a datetime, if we type 5.4 it thinks it is text, and our auto sum simply won't work, as it changes for every new row... How do we set the data type for a column to number, with 2 decimals ??

And how to we format a column to a short datetime: eg. 21:35 and finally a column as as datetime '10/10/2010'

Thx, overall we are very happy with this service and sharing is nice, but there's still a little work to be done :)