On May 5, 2:21*pm, Dave Peterson wrote:
I tried:
=text(a1,)
in B1.

If A1 contained text, it showed up nicely.

But if A1 was a number, I didn't see anything. *So I'm guessing you have a
number in that other cell.





webels wrote:

Hi
I have the following function extracting data from a seperate workbook

=TEXT([SurveillanceDup.xls]RDBMergeSheet!B2,)

Data is extracted to the new workbook

When I use
*=TEXT([SurveillanceDup.xls]RDBMergeSheet!A2,)

No data is extracted

There is data on Column A and B the SurveillanceDup.xls.

This is a strange one

Has anyone any ideas?

Thanks
Eddie

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Yeah Dave that is right, just remove text and do a direct extract from
A2 give the number.