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 (leaving the content) - Guide
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
- "Publish your article in rss format for other websites to syndicate" ✓ - Internet & Social Networks Forum
- Based on the cell values in cells b77 - Excel Forum
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
