Can't change format of cell [Closed]

Question

Can't change format of cell [Closed]

Report

Soo - Jan 31, 2016 at 08:41 PM
TrowaD

Posts: 2670
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 22, 2020

- Feb 9, 2016 at 11:13 AM

Hello,

Using Excel 2013.
I have a document which consists of various combinations for padlocks in a format of
00-00-00

most come out correctly, but when a number combination imitates a date
i.e. 30-5-68
the cell will revert to 30/5/1968. I cannot change the format of the cell and have to manually go and reenter them all as text with the apostrophe at the beginning,
which when I am dealing with about 500 combinations and around 300 are imitating dates, can be a tad annoying and time consuming.
Does anybody have a solution please?

Cannot change cell format in excel
Conditional Formating: formula cell text change color ✓ - Forum - Excel
Excel conditional formatting if cell contains specific text ✓ - Forum - Excel
Excel conditional formatting if cell contains any date - How-To - Excel
Highlight cell if another cell contains any text ✓ - Forum - Excel
Conditional formatting merged cells ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2016-02-01T11:33:21-0500

Answer 1 / 1

TrowaD

Posts: 2670
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 22, 2020

446
Feb 1, 2016 at 11:33 AM

Hi Soo,

Formatting as text should work.

Best regards,
Trowa

Report

Soo
Feb 1, 2016 at 06:28 PM

No. It doesn't. Tried that. But thanks anyway.

Report

TrowaD

Posts: 2670
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: October 22, 2020

446
Feb 9, 2016 at 11:13 AM

Hi Soo,

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

Your reply