Forum Discussion
Solved
PBI - How to eliminate the word Error or Null from cells, without eliminating rows or columns
E.G., when I changed the data type to DATE, Error appeared in the cells without dates. I want to eliminate that word Error without replacing it with any other information. I just want to have a blank cell when there is no date. I would appreciate much if somebody could help me. Thanks a lot.
Wilson
3 Replies
The fact is that I do not want the word Null, as well. Anyway, your suggestion was indeed good. I used "" instead of null. It worked out. Thanks a lot.
- mahoneypat
Microsoft Employee
FYI that you can also right click on the column header and choose Replace Errors to do the same.
Pat
