In your load statement, use the following statement and see if it works:
Num( EVALUATE(Your Field Here),'#0') As Newfield
Note: Replace "Your Field Here" with your field name.
Is there any possibility to change in Front end level. in app having 30+ sheets and if i go for reload i have to change all sheets paths.this is existing app some one developed.