Ask Your Question

Revision history [back]

Formatting cells does not and must not change the cell's data type. This is perfectly normal. Cell content data type is decided only when content is entered; and after that, no matter what formatting you apply to the cell, it will be preserved: formatting is about how the data is displayed, not about conversion between numbers and text. The only time the cell format is taken into account in relation with data type is at the moment of data entry, when it helps the program (hints) to decide what data type to expect.

Now you need to convert your existing data. This may be done using re-entry after cells have been formatted as text; or - better IMO - using DataText to Columns... feature, where you right-click the column and define Text as its type - then it will convert the whole column at once (which is the function it has been specifically created).

Formatting cells does not and must not change the cell's data type. This is perfectly normal. Cell content data type is decided only when content is entered; and after that, no matter what formatting you apply to the cell, it will be preserved: formatting is about how the data is displayed, not about conversion between numbers and text. The only time the cell format is taken into account in relation with data type is at the moment of data entry, when it helps the program (hints) to decide what data type to expect.

Now you need to convert your existing data. This may be done using re-entry after cells have been formatted as text; or - better IMO - using DataText to Columns... feature, where you right-click the column and define Text as its type - then it will convert the whole column at once (which is the function it has been specifically created).

See this screencast.