Converting Text to Number in 2000

  • Thread starter Thread starter bdunk
  • Start date Start date
B

bdunk

I have a spreadsheet that has a sum formula at the end of a column. Th
problem is that the last 7 or 8 values being summed seem to be text.
However, if you go to format cells they show up as numbers. In Offic
XP you can simply click on the Green arrow in the upper left han
corner and select convert to number. This fixes the problem and all i
well. In 2000 this function is not available. Is there a way t
convert these values without having to retype all the values in?

Thanks Bdun
 
Select the cells.
Give them a number format.
Data/text to columns/finish
 
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

Which is the best MBOX Converter Tool different formats conversion? 4
Convert Text to Number 1
Convert Numbers to Text 4
Having macro convert text to numbers 3
Excel Sum numbers in cells that also contain text 34
convert text to number 2
How to Convert EML to PST in 2025? 2
How to convert text to number? 9

Back
Top