| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Avoiding "0" importing blank cells from another Excel file
When importing data from another Excel spreadsheet, you get a 0 where there
was a blank cell. Can this be avoided? I tried to use If (B5=0," ",B5) which returns what looks like a blank cell, but really isn't. This drives statistics insane - sees it as 0 since it isn't a blank cell in reality. How can I avoid these problems without going through and physically deleting each 0? (find 0, replace with won't work since deletes any 0). I have thousands of data points. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Avoiding "0" importing blank cells from another Excel file
Jan K-A wrote: When importing data from another Excel spreadsheet, you get a 0 where there was a blank cell. Can this be avoided? I tried to use If (B5=0," ",B5) which returns what looks like a blank cell, but really isn't. This drives statistics insane - sees it as 0 since it isn't a blank cell in reality. How can I avoid these problems without going through and physically deleting each 0? (find 0, replace with won't work since deletes any 0). I have thousands of data points. Ty "" instead of " ". Maybe that's not the problem. sorry ed |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Avoiding "0" importing blank cells from another Excel file
On your original data, try formatting the cells so that they are text....or
at least something other than a number --maybe that would work. "ed" wrote: Jan K-A wrote: When importing data from another Excel spreadsheet, you get a 0 where there was a blank cell. Can this be avoided? I tried to use If (B5=0," ",B5) which returns what looks like a blank cell, but really isn't. This drives statistics insane - sees it as 0 since it isn't a blank cell in reality. How can I avoid these problems without going through and physically deleting each 0? (find 0, replace with won't work since deletes any 0). I have thousands of data points. Ty "" instead of " ". Maybe that's not the problem. sorry ed |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Avoiding "0" importing blank cells from another Excel file
Hi Jan,
What about If(B5="","",B5)? -- Cheryl "Jan K-A" wrote: When importing data from another Excel spreadsheet, you get a 0 where there was a blank cell. Can this be avoided? I tried to use If (B5=0," ",B5) which returns what looks like a blank cell, but really isn't. This drives statistics insane - sees it as 0 since it isn't a blank cell in reality. How can I avoid these problems without going through and physically deleting each 0? (find 0, replace with won't work since deletes any 0). I have thousands of data points. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CSV file with 13space characters in blank cells | Excel Discussion (Misc queries) | |||
| I get error messages in Excel cells once I save a file | Excel Worksheet Functions | |||
| Importing text file to excel | Excel Discussion (Misc queries) | |||
| existing excel file when clicked opens blank excel document | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
