Hello,
In one cell I am entering date and want to get it in another worksheet.
I use the formula ='FLEET DATA'!F19 where FLEET DATA is the name of the worksheet.
When I have an empty cell i get in the other worksheet 0/1/1900 and not an empty cell as I want.
any help?
Thank you!
you could use an If statement
=if('FLEET DATA'!F19 = "","",FLEET DATA'!F19 )
If you enter a number in a A1 lets says 4
in A2 you enter =A1 you get 4 in A2 the value of A1 passes to A2.
if you delete A1 you get 0 in A2, the value still passes to A2.
If you enter a date in A1 and then delete it the value still gets passed to A2.
0/1/1900 is the equivalent of 0 in Excel's date system.
Your formula should read
=IF(A1=0,"",A1)
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Neither of two solutions working
Thank anyway for your time!
Thank you but problem fixed!!
I used the following
=IF('FLEET DATA'!B10=01/1/1900;"";'FLEET DATA'!B10)
for dates and
=IF('FLEET DATA'!B10=0;"";'FLEET DATA'!B10)
for text
So now i get empty cells instead of 0/1/1900 or 0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks