Thread
:
Converting cells to numbers
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
readystate
external usenet poster
Posts: 25
Converting cells to numbers
I have a spreadsheet with a column of numbers formatted as follows
1111-111-111
I need to omit the - in both places so that I end up with just the digits
formatted as numbers. Any suggestions???
Reply With Quote
readystate
View Public Profile
Find all posts by readystate