Forum Discussion
Hiding "1/0/1900" when representing empty date formatted cells
I have two sheets in a workbook. Call them sheet "1" and "2". A particular cell in sheet 1 references (pulls from) a particular cell in sheet 1. Both cells in both sheets are "date" formatted. Wh...
MarkSanDiego Perhaps a formula like this will work better:
=IF(ISBLANK(Sheet2!A1),"",Sheet2!A1)It will first look is there is something in A1 on Sheet2. If it's empty return an empty string, else return what's in Sheet2!A1.
If I may recommend you...
An example file would be very helpful in suggesting a solution...for you.
Drag and drop here or browse files to attach
Maximum size: 71 MB • Maximum attachments allowed: 5
Knowledge of the Excel version would be an advantage.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
No worries now....I found the solution. It is, custom format with: mm/dd/yyyy;"1/0/1900";;@
But thank you anyway!
But thank you anyway!
- I'm glad you came to a solution.
Thanks for the feedback. - How did you figure this out??? This is great
MarkSanDiego how did you sort this? im in a similar situation 2 years later.. lol
