I am using a formula to copy cells from one sheet to another.
Everything is ok except the date column.
The when that cell is "" or -0- it shows 1/0/1900
How can I change this to "-" or blank?
Many thanks
I am using a formula to copy cells from one sheet to another.
Everything is ok except the date column.
The when that cell is "" or -0- it shows 1/0/1900
How can I change this to "-" or blank?
Many thanks
One way:
=IF(Sheet1!A1>0,Sheet1!A1,"")
In article <[email protected]>,
"seve" <[email protected]> wrote:
> I am using a formula to copy cells from one sheet to another.
>
> Everything is ok except the date column.
>
> The when that cell is "" or -0- it shows 1/0/1900
> How can I change this to "-" or blank?
>
> Many thanks
Just what I needed....thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks