Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Just what I needed....thank you!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
How can I make the bar that shows the content of the cell visible. | Excel Discussion (Misc queries) | |||
Excel formatting of text-- one cell needed | Excel Discussion (Misc queries) | |||
Cell Formatting | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |