IN this code, i know the trim will go but i am just wondering where it will go because the format of the number is having space and its wrong <cfset form.hours = '0 .00'> <cfset rownum = 1> <cfset tmpHours = NumberFormat(trim(form["hours" & rownum]), "-000.00")> <cfdump var="#tmpHours#">

trim

will remove leading and trailing whitespace. It won't remove spaces in the middle of your string. If you want to remove all spaces / whitespace in your string then use

replace

/

rereplace

ah ok, where i need to put that replce or rereplace

Depends if you actually want the user to be able to input

0 . 00

or whatever as it's not really valid.

its not use4d based, its doing internally

Something like this https://cffiddle.org/app/file?filepath=f96f61d3-d071-416b-bae0-6150411def93/e254a034-22c3-4c51-901d-a0d0f2b77034/11966e93-6c55-453a-94bd-ced8535313c6.cfm