ExcelBanter - Formatting Cell to text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting Cell to text (https://www.excelbanter.com/excel-discussion-misc-queries/43335-formatting-cell-text.html)

Dawn

Formatting Cell to text

When I have numbers in a cell and try to format them as text they do not all
change to text.

Dave Peterson

They won't change to text until you make your next change to the value.

Selecting the cell, hit F2, then enter is enough.
(after you've changed the format to Text)

Dawn wrote:

When I have numbers in a cell and try to format them as text they do not all
change to text.

--

Dave Peterson

All times are GMT +1. The time now is 04:49 AM.