Problems with FREQUENCY and '

[Guest]

I am trying to use the frequency command, which I've had no problem with before, but this time, it's not working. I think it's because the column with the numbers in it is preceded by an apostrophe ('), like the old Lotus style.

Is there anyway to transfer this column of numbers without the ', or is there any way to strip the ' out of the column?

This is probably a file that was previously in DBIV.

 

[Mark W.]

Select 'em and choose the Data | Text to Columns... menu command.

 

[Aladin Akyurek]

On 2002-03-12 12:16, Anonymous wrote:
I am trying to use the frequency command, which I've had no problem with before, but this time, it's not working. I think it's because the column with the numbers in it is preceded by an apostrophe ('), like the old Lotus style.

Is there anyway to transfer this column of numbers without the ', or is there any way to strip the ' out of the column?

This is probably a file that was previously in DBIV.

Put a 1 in a cell, copy this cell, select the range of interest with quoted numbers, activate Edit|Paste Special >Multiply.

 

[Guest]

Thanks aladin, that worked...I **NEVER** would have thought of doing it that way.