Avatar of cansevin
cansevin
 asked on

Formating as number

I have vlookup that isn't working properly and i believe it is because the cell I am trying to lookup isn't properly formated as a number.

I am trying to look up a cell in E1, it is a zip code. It is a formula that says =Right(D2,5) which pulls the last 5 characters from the cell next to it. How can I tell excel to recognize this zip code as a number?
Microsoft Excel

Avatar of undefined
Last Comment
cansevin

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
IrogSinta

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.
cansevin

ASKER
You the man! Thanks!!!!!
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck