Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

Need convert a number to

I have  data i need to ajust

for example
if the number is  534  I need to convert in 435

have to be even  first in this order
2 4 6 8 0 and odd in this order 1 3 5 7 9
lets say

288 =288
958=859
123=213
ectt..
regular-to-adjusted.xlsx
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
ADRIANA P

ASKER
Shums !! Good friend !

is very interesting funtion !

but don't work !! in this case
the number have to be

in order from 2 4 6 8 0 beging always!!
ADRIANA P

ASKER
lets say
695 =659
731=137

oder of odd = 1 3 5 7 9
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Martin Liss  That what i need !!

FAST SIMPLE AND CORRECT !
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ADRIANA P

ASKER
Martin Great Expert ! Greates Solutions ! Always !!
ADRIANA P

ASKER
Great!!  solutions always from you !!
Martin Liss

You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2016
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2016
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
i will be there !