Convert text to numeric value and keep all decimals?

[Anonymous]

Some of the data are numbers, stored in text fields. When converting using:

NUM#([Text Result], '#') AS [Result]

... it can give the following results:

I want the same precision for the numeric value as the original text value, however this is not always what the code delivers. Why is the last two zeroes removed from row 4, but kept in row 2? How do I achieve what I need, what conversions are necessary?

[Gysbert_Wassenaar]

Num(NUM#([Text Result], '#'),'#.000') AS [Result]

[Anonymous]

Still doesn't work:

Zeroes are sometimes still cut off.

[Gysbert_Wassenaar]

Works for me. See attached example