Link to home
Start Free TrialLog in
Avatar of davidtotty
davidtotty

asked on

Insert Decimal Point

This is probably very simple but I need to change a value from:

123456

 to:

1234.56

Does anyone have any suggestions?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Pavel Celba
Pavel Celba
Flag of Czechia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of davidtotty
davidtotty

ASKER

Thanks that worked nicely :)
I should also mention STUFF() function:

StrValue = "123456"
? STUFF(StrValue, 5, 0, '.')

And remember if the value is stored in a numeric table column which has no decimal places then you cannot simply replace it by a new value with decimal places. The REPLACE command will round the result.
Thanks pcelba :)

It was a numeric table column without decimal places. I should have made that more clear.

David