Formatting numbers as text

  • Thread starter Thread starter Shirley Munro
  • Start date Start date
S

Shirley Munro

Can anyone tell me why cells containing figures which have bee
formatted to text in some instances still see the figures as number
and not as text. I have discovered that if I format the cells to tex
and then double click on each cell which contains a figure I would lik
to be seen as text then this fixes it but this is time consuming i
there are several cells
 
Shirley

Re-formatting numbers to text just changes the way they are displayed, but
does not change the underlying fact that these are numbers.

You can enter the numbers as text by placing an apostrophe then the number or
by pre-formatting the range as Text before entering the numbers.

After the fact you can select the cell(s) and Data>Text to Columns>Next>Next.
In Step 3 check "Format column as:" Text.

Gord Dibben XL2002
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers change in cell even when formatted as text 4
Custom Number Format for text 8
Conditional formatting 3
Changing Text To Numbers ? 1
How to do double quotes in "cell language"? 4
Conditional Format Range of Cells 3
Conditional Formatting Question 3
Min and Max Dates in Range that Contains Zeroes, Dates, and Number 5

Back
Top