Two Formats in one cell
Closed
TED
-
Aug 27, 2009 at 06:50 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 27, 2009 at 09:06 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 27, 2009 at 09:06 PM
Related:
- Two Formats in one cell
- Clear only the formatting from the selected cell - Guide
- Cell phone codes - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- "Publish your article in rss format for other websites to syndicate" ✓ - Internet & Social Networks Forum
- Excel cell color formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 27, 2009 at 09:06 PM
Aug 27, 2009 at 09:06 PM
suppose the entries are in A1 and B1
the formula will be
=TEXT(A1,"mm/dd/yy")&B1
the formula will be
=TEXT(A1,"mm/dd/yy")&B1
