Hi Don Stephen Lambatin,
Thanks for your solution Don, I have Tired your formula it's working but my case was to enter only 6 characters and i need to modify it .
Ex :Entering the values like 123456 after conversion the value was $123,456.00
Now we need to replace 4 number with 8 and that should reflect like $123,856.00 but for ...