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
123456
to:
1234.56
Does anyone have any suggestions?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
Thanks pcelba :)
It was a numeric table column without decimal places. I should have made that more clear.
David
It was a numeric table column without decimal places. I should have made that more clear.
David
ASKER