Oracle import

S

Steved

Hello from Steved

If I have a 4 Digit the below "Formula" works as it should.

Excel shows "141" as 141 in Formula Bar but the Oracle Import shows it as
0141 in the Formula Bar

"Oracle import" is in sheet named "Duties Mon-Fri"

Please What do I Need to do for the Formula below to accept either to
function Thankyou.

{=INDEX('Duties Mon-Fri '!$F$2:$F$60000,MATCH(B6 &CHAR(1) &C6,'Duties
Mon-Fri '!$B$2:$B$60000 & CHAR(1) &'Duties Mon-Fri '!$G$2:$G$60000,))}
 
S

Steved

Hello from Steved

from this $B$2:$B$60000
to this $B$2:$B$60000+0

Yes it was treating it as text.

Thankyou.
 
M

Max

Instead of eg: =match(a1,..)
Try it like this: =match(text(a1,"0000"),..)
which will pad a leading zero to the number in A1 as required, besides
converting it to text as well, for consistency in matching
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top