So, 1000 (one thousand)is really 10.00 (ten)
In a blank cell, enter .01 and copy. Select your cells and do a Paste Special>Multipy. Format as number with 2 decimal places.
If you, however, wish to retain the value of one thousand but display it as 10.00, then choose Format>Cells>Number Tab> Custom. For type, enter
##"."00
lenze