Excel

Hi Eric,

Thank you for the forum question.

I know what I would do but this involve VBA programming in Excel.

Unfortunately there is no tools in Excel which can do it. You will need to do the calculation and copy and paste.

If you know about VBA I have created two solutions.

If you add the following code into a module in the Visual Basic Editor in the workbook and run it all numbers in the worksheet will be divided by 100.

Sub ConvertToPoundAllNumbers() 'Code start

For Each cell In Cells.SpecialCells(xlCellTypeConstants, xlNumbers)
cell.Value = cell / 100
Next cell
End Sub 'code end

If you don't want all numbers divided with 100 you can select the numbers and use the code below and all numbers in the selection will be divided by 100.

Sub ConvertToPoundSelection() 'code start
For Each cell In Selection
cell.Value = cell / 100
Next cell
end sub 'code end


VBA in Excel is very powerful and can save us a lot of time.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector