You need to format your original reference as text not a number - otherwise any formula like T.Valko's will truncate the string so something that displays like 123456.12340 will return 1234 because even if your number format is to show 5 dp in the original cell Excel only carries the significant figures internally.
A supplementary thought is that surely if the part after the decimal point is a sequence number then
123456.999
should be followed by
12456.1000
and you need to pad the front of your number with zeros otherwise you will get 999 turned into 9990 which is followed by 1000!
So I think you have to do the following:
Turn all your data into text
Drop the bit to the left of the DP using a formula like this
=(--MID(B9,FIND(".",B9)+1,LEN(B9)-FIND(".",B9)+1))
Excel will generally interpret this as a number (in 2007 and later at the least) but I think some earlier versions of Excel might need this wrapped in a VALUE function to turn the text into numbers - you need to check if you use an older version.
If I am right and 999 should display as 00999 then you can force this to happen by using a custom number format with 00000 as the code in the format field.