LinkBack URL
About LinkBacks
HI. I want to place blank (" ") on entire column . there are so many "00-01-1900" values . so i want to replace as blank (" "). is it possible by VBA.
Please guide me
heaps thanks in advance
HI. I want to place blank (" ") on entire column . there are so many "00-01-1900" values . so i want to replace as blank (" "). is it possible by VBA.
Please guide me
heaps thanks in advance
You could do a find and replace...
Or, if you select a range of cells and type in a value and then hit Ctrl+Enter it will fill in that range with the value that you entered into the first cell.
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
Where does 00-01-1900 come from?
That is generally a cell formatted as date, that contains 0
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Yes. You are right. Its actually 0 but that column has been formatted to date format. If vlookup returns blank in date formatted column, it gives 00-01-1900. Can you please help me out. ThanksOriginally Posted by FDibbins
Perhaps something like...
=is(your-formula<1,"",your-formula)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks