Want to see as numbers not text

C

chrisdtran

:confused:
I have a very large data. In general, it looks like the below. Column
A & B are my daily entry. Columns C & D are my database that shows al
the daily entries for 30days.
A B C D E
1 Product 3 10 Product 1 30 30
2 Product 5 20 Product 2 0 0
3 Product 1 30 Product 3 10 10
4 Product 4 0 0
5 Product 5 20 20
6 Product 6 0 0

In column D, I have the formulas copied all the way down:
D1
if(iserror(vlookup(C1,A1:B6,2,false),"0",vlookup(C1,A1:B6,2,false))
Then I copy column D and paste special (values) to column E.
With all cells formatted as number, but all the "0" values in column
show the error message that they are "formatted as text or precedede
by an apostrophe". what should i do to have them displayed as numbers

I can convert them one by one using the error checking, but that is to
much for a large file.
Thanks a lot
 
J

JulieD

Hi

one idea - select an unused cell (even one from anoth worksheet) and copy
it, then select column E and choose edit / paste special - add ..
this might solve your problem

Cheers
JulieD
 
Top