Thread: converting a text column to a number column & removing the '
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default converting a text column to a number column & removing the '
--Copy a blank cell.
--Keeping the copy select your data range
--Right clickPasteSpecialselect 'Add'Click OK

If this post helps click Yes
---------------
Jacob Skaria


"Gayle from CyberCore" wrote:

I have a large spreadsheet with a column of information that was set up as
text even though the contents are numbers.
I want to highlight the whole column and perform a function that will
eliminate the ' before each number.

Can that be done?
Reply With QuoteReply With Quote