<div>
Custom format the formula cell with <b>dd/mm/yyyy;;</b> to hide 1900-01-00.
</div>


<div>
I cannot do that.. the required format is yyyy-mm-dd &nbsp;because if it is not blank it needs to stay and use the date and in that specific reformat.
</div>


<div>
it is already.... &nbsp;I need it to be blank without the 1900-01-00 showing &nbsp; &quot;&quot;
</div>


<div>
any other value is acceptable &gt;&nbsp;today. &nbsp;I am having issue making the cell = &quot;&quot;
</div>


<div>
ohhhh &nbsp;hello the suffix of ;; &nbsp;that worked. &nbsp;I feel tiny.
</div>


<div>
Okay I made them bold so that you don't miss the complete syntax.<br />
Glad it worked at last for you.
</div>


<div>
You're welcome. Glad to help.
</div>


<div>
<div class="content wysiwyg-content">
If the following Ln on a sheet, grabs a value and that value is a Date.<br />
<br />
ActiveWorkbook.Names.Add Name:=&quot;ColI&quot;, RefersToR1C1:=&quot;=&quot; &amp;&nbsp;Me.Name &amp;&nbsp;&quot;!R&quot; &amp;&nbsp;Target.Row &amp;&nbsp;&quot;C9&quot; ' LnReqDelDate<br />
<br />
however if the cell it is grabbing in column 9 from, is blank it returns: &nbsp;1900-01-00<br />
<br />
I use the formula on =ColI on another sheet to put that value in.<br />
Is there another way to write the formula &nbsp;=ColI so that if it returns 1900-01-00 (meaning blank) , it can make it &quot;&quot;&nbsp; &nbsp; &nbsp;??
</div>
</div>


If the following Ln on a sheet, grabs a value and that value is a Date.

ActiveWorkbook.Names.Add Name:="ColI", RefersToR1C1:="=" & Me.Name & "!R" & Target.Row & "C9" ' LnReqDelDate

however if the cell it is grabbing in column 9 from, is blank it returns:  1900-01-00

I use the formula on =ColI on another sheet to put that value in.
Is there another way to write the formula  =ColI so that if it returns 1900-01-00 (meaning blank) , it can make it ""     ??

Trying to make a formula blank.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.