Text to value - Resolved - Thanks :)

LuvlyRitaa · May 7th, 2002, 01:07 PM

I have a worksheet that was exported into excel. The numbers in this worksheet are text and I'd like to convert them to numbers. I've used the =value() formula when converting a cell or two, but I'm looking for an easier way to convert the spreadsheet from text to values. Any ideas?

Thanks!

_________________
Rita~~

"Baseball is like church, many attend, few understand." Leo Durocher

[ This Message was edited by: LuvlyRitaa on 2002-05-07 17:25 ]

zacemmel · May 7th, 2002, 01:13 PM

(before doing this, make sure ALL cells are formatted as general or number)

Put a 1 into a blank cell. Right click that cell, goto copy. Highlight the range of text that you want to be converted to values. Right click the highlighted range, select paste special. Then, select values and multiply. Click ok.

Mark W. · May 7th, 2002, 01:31 PM

Quote:

On 2002-05-07 12:07, LuvlyRitaa wrote:
I have a worksheet that was exported into excel. The numbers in this worksheet are text and I'd like to convert them to numbers. I've used the =value() formula when converting a cell or two, but I'm looking for an easier way to convert the spreadsheet from text to values. Any ideas?

Thanks!

Select your numbers, choose the Data | Text to Columns... menu command, and press [ Finish ].

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 01:07 PM	#1
LuvlyRitaa New Member Join Date: May 2002 Location: Grapevine, Texas Posts: 14	I have a worksheet that was exported into excel. The numbers in this worksheet are text and I'd like to convert them to numbers. I've used the =value() formula when converting a cell or two, but I'm looking for an easier way to convert the spreadsheet from text to values. Any ideas? Thanks! _________________ Rita~~ "Baseball is like church, many attend, few understand." Leo Durocher [ This Message was edited by: LuvlyRitaa on 2002-05-07 17:25 ]

May 7th, 2002, 01:13 PM	#2
zacemmel Board Regular Join Date: Apr 2002 Location: Redmond, WA Posts: 636	(before doing this, make sure ALL cells are formatted as general or number) Put a 1 into a blank cell. Right click that cell, goto copy. Highlight the range of text that you want to be converted to values. Right click the highlighted range, select paste special. Then, select values and multiply. Click ok.