Re: Formatting cells so VLOOKUP works

["Leroy, Bertrand" <Bertrand.Leroy@RBS.CO.UK>]

for the users who don't have XP, you can select the column containing that
data and then go to Data > Text to columns ... press finish ... and your
numbers that are seen as text by Excel will then be seen as numbers!

HTH,

Bertrand

> -----Original Message-----
> From: Gary Birch [SMTP:gbirch@TYCO-BSPD.COM]
> Sent: 28 July 2003 13:13
> To:   EXCEL-G@PEACH.EASE.LSOFT.COM
> Subject:      Formatting cells so VLOOKUP works
>
> *** WARNING : This message originates from the Internet ***
>
> 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


The Royal Bank of Scotland plc ('the Bank') is regulated by the Financial
Services Authority and is a member of The Royal Bank of Scotland Marketing
Group.  The only packaged products (life policies, unit trusts and other
collective investment schemes and stakeholder and other pensions) the Bank
advises on and sells are those of the Marketing Group, whose other members
are Royal Scottish Assurance plc and Royal Bank of Scotland Unit Trust
Management Limited, both regulated by the Financial Services Authority.

The Royal Bank of Scotland plc. Registered in Scotland No 90312.  Registered
Office: 36 St Andrew Square, Edinburgh EH2 2YB.

Agency agreements exist between members of The Royal Bank of Scotland Group.

This e-mail message is confidential and for use by the addressee only. If
the message is received by anyone other than the addressee, please return
the message to the sender by replying to it and then delete the message from
your computer. Internet e-mails are not necessarily secure. The Royal Bank
of Scotland plc does not accept responsibility for changes made to this
message after it was sent.

Whilst all reasonable care has been taken to avoid the transmission of
viruses, it is the responsibility of the recipient to ensure that the onward
transmission, opening or use of this message and any attachments will not
adversely affect its systems or data. No responsibility is accepted by The
Royal Bank of Scotland plc in this regard and the recipient should carry out
such virus and other checks as it considers appropriate.

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