Excel Date formatting problem
Solved/Closed
chow70
chow70
- Posts
- 2
- Registration date
- Sunday September 20, 2009
- Status
- Member
- Last seen
- September 22, 2009
chow70
- Posts
- 2
- Registration date
- Sunday September 20, 2009
- Status
- Member
- Last seen
- September 22, 2009
Related:
- Excel Date formatting problem
- Excel date format dd/mm/yyyy - Guide
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Excel conditional formatting entire column based on another column ✓ - Forum - Excel
- Excel conditional formatting if another cell contains any text ✓ - Forum - Excel
2 replies
chow70
Sep 22, 2009 at 10:19 AM
- Posts
- 2
- Registration date
- Sunday September 20, 2009
- Status
- Member
- Last seen
- September 22, 2009
Sep 22, 2009 at 10:19 AM
You can't do it when the link to the cell is imbedded within a formula. For example, when you type this for a formula in a cell
="11-05100-0"&B3
where the cell B3 equals 8/31/09
it comes out looking like
11-05100-040056
when I need it to look like
11-05100-08312009
Anybody have any ideas?
="11-05100-0"&B3
where the cell B3 equals 8/31/09
it comes out looking like
11-05100-040056
when I need it to look like
11-05100-08312009
Anybody have any ideas?