Home Computer Repair How To Move Decimal Places in Microsoft Excel

How To Move Decimal Places in Microsoft Excel


If you’re dealing with a couple of cells in Excel, changing decimal places manually is simple. Double click and add it where you want to move it to and you’re done. When you’re dealing with larger spreadsheets with hundreds of entries, it becomes more challenging. Fortunately, there are a few ways to move decimal places in Excel.

I work a lot in Excel even though I wish I didn’t. I have developed a few quick techniques for getting things done and this is one of them. I won’t pretend I figured them out because I didn’t. Friends who know a lot more about Excel than I do helped me out and now it’s my turn to pay it forward.

I use Excel 2016 so these instructions relate to that version. Office 365 or older versions of Excel should be similar if not the same.