Re: Formatting cells so VLOOKUP works

[Don Guillett <donaldb@281.COM>]

another one
Sub FixRangeValues()
For Each C In Selection
C.Value = Format(C, "00")
Next
End Sub

Don Guillett
SalesAid Software
Granite Shoals, TX
donaldb@281.com
----- Original Message -----
From: "Gary Birch" <gbirch@TYCO-BSPD.COM>
To: <EXCEL-G@PEACH.EASE.LSOFT.COM>
Sent: Monday, July 28, 2003 10:32 AM
Subject: Re: Formatting cells so VLOOKUP works


> Thanks a million!!! Works fine.
>
> Gary.
>
>
>
>
>                       Geoff Barraclough
>                       <Geoff.Barraclough@PUNCH        To:
EXCEL-G@PEACH.EASE.LSOFT.COM
>                       PUBS.CO.UK>                     cc:
>                       Sent by: MS Excel               Subject:  Re: Formatting
cells so VLOOKUP works
>                       General Q & A List
>                       <EXCEL-G@PEACH.EASE.LSOF
>                       T.COM>
>
>
>                       28/07/03 16:07
>                       Please respond to MS
>                       Excel General Q & A List
>
>
>
>
>
>
> Enter a 1 in a blank cell
> Copy it
> Select all your "numbers" that are actually text
> Edit>PasteSpecial>Values
> Tick Multiply
>
> Et voila - all your "text numbers" are now real numbers
>
> Rgds
> Geoff
>
> ******* ******** ********** ******* ***** ** ******* ***** ********
> ****** **********
>
> >  -----Original Message-----
> > From:         MS Excel General Q & A List
> > <EXCEL-G@PEACH.EASE.LSOFT.COM>@ADLANS   On Behalf Of Gary Birch
> > <gbirch@TYCO-BSPD.COM>
> > Sent: 28 July 2003 13:13
> > To:   EXCEL-G@PEACH.EASE.LSOFT.COM
> > Subject:      Formatting cells so VLOOKUP works
> >
> > Hi there,
> >
> >       I've noticed that sometimes after running a query or pasting
> > data
> > into a spreadsheet I am unable to get VLOOKUP to work. The problem
> > seems to
> > be that the cell containing the data I am looking up is formatted
> > differently to the corresponding cell in the table in which vlookup is
> > looking.
> >       The only way I can get around this is either copying the cell
> > exactly
> > from one sheet to another (which is very time consuming!) or
> > formatting the
> > column as text and then going down the column hitting F2 then enter.
> > This
> > seems to allow the lookup to work properly.
> >       Does anybody know why this happens and if there is a way of
> > getting
> > around it. I'm using office XP. Not sure if other versions of office
> > have
> > this problem.
> >
> >       PS (I know this is slightly unusual, but I need some extra RAM
> > and
> > I've noticed that you can get registered or non-registered RAM. Is it
> > worth
> > paying extra for the registered or not?)
> >
> > Thanks for your help,
> >
> > Gary.
> >
> > ----------------------------------------------------------------------
> > ----
> > The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
> > international's LISTSERV(R) software.  For subscription/signoff info
> > and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
> >                              COPYRIGHT INFO:
> > http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the sender.
>
> **********************************************************************
>
> --------------------------------------------------------------------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
> international's LISTSERV(R) software.  For subscription/signoff info
> and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
> --------------------------------------------------------------------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
> international's LISTSERV(R) software.  For subscription/signoff info
> and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
>                              COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G