Query to update last 2 digits of a numeric field

85 pts.
Tags:
Microsoft Excel
I have few records in a column of length 6. Now I want to update the last 2 digits of them with other number. eg:- 12360, 453560, 6760, 124560 and 6060 these are the records I have. Now I want to update only the last 2 digits '60' with 58 (no other places to be updated). Is it possible to do? Can anyone please help with query. Thanks in advance!
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Are you looking for a formula or a macro? I don't believe there is a find/replace option that will work for you.
    133,595 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: