Can't change format of cell
Closed
Soo
-
Jan 31, 2016 at 08:41 PM
TrowaD
TrowaD
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Related:
- Can't change format of cell
- Cannot change format of cells in excel ✓ - Forum - Excel
- Conditional Formating: formula cell text change color ✓ - Forum - Excel
- Conditional formatting if cell does not contain specific text ✓ - Forum - Excel
- Change format of date in excel - Guide
- Conditional formatting if cell contains date - Guide
1 reply
TrowaD
Feb 1, 2016 at 11:33 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Feb 1, 2016 at 11:33 AM
Hi Soo,
Formatting as text should work.
Best regards,
Trowa
Formatting as text should work.
Best regards,
Trowa
Feb 1, 2016 at 06:28 PM
Feb 9, 2016 at 11:13 AM
I see what you mean as it only works for new entry's.
What does seem to work is formatting the column as date: dd-mm-yy.
Hopefully that helps.
Best regards,
Trowa