Hi,
I would like to combine text and date with formula. The date is showing as date number. But I want to see date as date only.
Excel file attached with relevant info.
Pl. help.
Thanks,
Nagesh.
Hi,
I would like to combine text and date with formula. The date is showing as date number. But I want to see date as date only.
Excel file attached with relevant info.
Pl. help.
Thanks,
Nagesh.
Replace your E8 Formula with the below one
="Production as on ("&TEXT(E6,"dd-mmm)")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thank you. I got it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks