ExcelBanter - Cell formatting - "" shows as 1/0/1900

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell formatting - "" shows as 1/0/1900 (https://www.excelbanter.com/excel-discussion-misc-queries/3936-cell-formatting-%22%22-shows-1-0-1900-a.html)

seve

Cell formatting - "" shows as 1/0/1900

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

JE McGimpsey

One way:

=IF(Sheet1!A10,Sheet1!A1,"")

In article .com,
"seve" 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

seve

Just what I needed....thank you!

All times are GMT +1. The time now is 02:51 AM.