Want to see as numbers not text

  • Thread starter Thread starter chrisdtran
  • Start date Start date
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
 
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
 
Back
Top