How to reformat numbers stored as text (apostrophe at beginning)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to reformat a list of numbers so the first number of each
entry does not have an apostrophe? I think it means the numbers are being
treated like text. I have tried replacing '1 with 1 and ' with (blank). I
have changed the formatting on the cell to accounting, even though I know it
will not change the text. Can this be done, because I need to reference the
numbers in a DSUM and the criteria I have are numbers not text.

Thanks
 
Copy an empty cell. Select your text numbers. Choose Edit/Paste Special,
selecting the Values and Add radio buttons.

This will coerce the text numbers to actual numbers.
 
You must log in or register to reply here.

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

Apostrophe in Numbers 5
Adding an apostrophe to a column of numbers 6
Formatting to text - apostrophe does not show 3
Number Text Format 2
Remove Trailing Apostrophe 1
Can I replace a ' at the beginning of a text cell using Replace 4
Replacing Apostrophize at Beginning of Cell 3
numbers as text 1

Back
Top