Formatting Number in text field

[MTSPEER]

Hello,

I'm trying to format the number in standard formatting. The text field name is Field1. But for some reason when I runt he query it's just giving me blank answers. The number's are formatted like this "0000.00". I just want them to be standard formatting like 34.27

[ranman256]

format is as Currency without the $ symbol.