| 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) | |||
Linear Mode
