When I moved data from one workbook to another...

N

Newbie1

When I moved data from one workbook to another (different column structures
so I pointed to the correct column, but most I did not run through any
"formulas")
What has happened is that many fields that were empty, got a value of 0
(ZERO), not blank.
I have 2 questions:
Why?
And (more important....) how can I correct this after the fact? I have been
using the data, so I can not really re-import it.

Thanks,
Bruce
 
J

Jim Rech

Due to newbie-speak it's not clear what you're asking<g>. If it is that a
formula returns a zero when referencing an empty cell, that is normal. One
option is a formula like =IF(A1=0,"",A1). Another is to not display zero
values in a window (Tools, Options, View, Zero Values.

--
Jim Rech
Excel MVP

| When I moved data from one workbook to another (different column
structures
| so I pointed to the correct column, but most I did not run through any
| "formulas")
| What has happened is that many fields that were empty, got a value of 0
| (ZERO), not blank.
| I have 2 questions:
| Why?
| And (more important....) how can I correct this after the fact? I have
been
| using the data, so I can not really re-import it.
|
| Thanks,
| Bruce
|
|
 
Top