Converting all data in column with multiplier ( *1)

[bojzon]

(excel 2000, xls)
In selected columns need every cell convert data to NUMBER with multiplier *1.
Is there any quicker way than cell by cell?

Thanks

Bojzon

 

[macropod]

Hi Bojzon,

1. Enter the number '1' in any unused cell.
2. Copy the cell
3. Select the range that you want to modify
4. Choose Edit|Paste Special, then 'Values' and 'Multiply'
5. Click OK.

If you need to do this often, you could set up a macro to automate the process, and attach it to a button or keyboard shortcut.

Cheers

 

[UniqueFD]

You could use a macro:

Sub Macro1()
Do While ActiveCell <> 0:
    ActiveCell = (ActiveCell * 1)
    ActiveCell.Offset(1, 0).Select
    Loop
End Sub

Asign this to a CTRL key, got to the top of the column and start the macro.

Tony
___________________________________________________
Reckless words pierce like a sword,
but the tongue of the wise brings healing (Solomon)