Converting cells to numbers

's Computer Specifications

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???

's Computer Specifications

Ctrl-H

Replace - with nothing

--
__________________________________
HTH

Bob

"readystate" <(E-Mail Removed)> wrote in message
news:1327DD3B-C644-4882-8FFB-(E-Mail Removed)...
>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???

's Computer Specifications

Man...that was so easy, I really should have thought about it myself. Thanks
much - you saved me a lot of trouble.

"Bob Phillips" wrote:

> Ctrl-H
>
> Replace - with nothing
>
> --
> __________________________________
> HTH
>
> Bob
>
> "readystate" <(E-Mail Removed)> wrote in message
> news:1327DD3B-C644-4882-8FFB-(E-Mail Removed)...
> >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???
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting text to numbers, but not blank cells	Anika V. Bristalli	Microsoft Excel Discussion	2	15th Aug 2007 09:02 PM
Converting colored cells to numbers- is there a formula?	=?Utf-8?B?TWF0aCBHZWVr?=	Microsoft Excel Worksheet Functions	1	23rd Feb 2007 08:36 PM
Converting negative numbers stored as text to numbers	=?Utf-8?B?QUthbXJhbg==?=	Microsoft Access	2	25th May 2006 04:03 PM
Converting negative numbers stored as text to numbers	=?Utf-8?B?QUthbXJhbg==?=	Microsoft Access	0	25th May 2006 03:54 PM
Converting negative numbers in a range of cells to zero	Dede	Microsoft Excel Misc	3	14th Jan 2005 06:23 PM