Solved

Formating as number

Posted on 2012-12-20

Microsoft Excel

1 solution

176 Views

Last Modified: 2012-12-20

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?

Comment

Question by:cansevin

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 29

Accepted Solution

by:IrogSinta

IrogSinta earned 500 total points

ID: 387117392012-12-20

Try =Value(Right(D2,5))

Author Closing Comment

by:cansevin

ID: 387117442012-12-20

You the man! Thanks!!!!!

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel - Did You Know !

Article by: Shums

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…

Deleting Shapes - A Warning

Article by: Martin

This article describes a serious pitfall that can happen when deleting shapes using VBA.

Building Probability Models in Excel Part 4: Discrete Random Variables

Video by: Toby

The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…