Number stored as text

G

Guest

I have number stored as text. It has a small green triangle at the upper
left of the cell. If I click on the cell it has a yellowsign with a ! and if
I click on that a menu and "convert to number"
This works fine one cell at a time.

I need to convert columns the cell format has no effect on the column of
cell I need to change. I did un click the protect on the last tab.

Suggestions?
Sueanne
 
D

Dave Peterson

copy an empty cell.
select your range of offending cells
Edit|paste special|check Add
 

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

What is small green triangle in upper left corner of cell? 6
Number stored as text 3
How do I ignore the "Number stored as text" error message permane. 3
Non matching text data of the same values 3
formatting cells with numbers as text 2
Need help converting Number stored as Text to Date 4
Formatting to text - apostrophe does not show 3
How to prevent a number stored as text from converting to a number 2

Top