if i paste '12/2012' this data in A1 cell then it will show dec-2012. how to change this automatically change option?
if i paste successfully in "A1" as 12/2012 Then i need to display that data in C1. I am using a formula in C1 Which is =A1&""
now am getting some numbers in C1 instead of 12/2012.
41974 This is the number I am getting in C1 cell instead of 12/2012
I want display same data, same look in C1 cell.
Last edited by vengatvj; 06-29-2016 at 08:22 AM.
Try this ...
=IF(ISTEXT(A1),A1,TEXT(A1,"mm/yyyy"))
Or format the cell as TEXT 1st
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
your formula working well, but B1 cell display the value "01/1900" when A1 is emply, I want blank in B1 when A1 is emply
Try ...
=IF(A1=0,"",IF(ISTEXT(A1),A1,TEXT(A1,"mm/yyyy")))
That will work if the cell contains 0. If it is empty (has no data)...Originally Posted by Phuocam
=IF(A1="","",IF(ISTEXT(A1),A1,TEXT(A1,"mm/yyyy")))
Equipvalent to this...
=TEXT(A4&"","mm/yyyy")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks