Excel – inserting a decimal point to number in excel

cell formatmicrosoft excel

I've currently got a list of numbers example. 123456 I need to add a three decimal point into the number example. 123.456 I've changed the settings in the options but I have to then type out over 250,000 numbers. is there a formula I can use to automatically do this instead of having to double click or retype the numbers to correct it?

Best Answer

If you just need to format the numbers with a point after three digits from the right, try this:

  1. Select the cells or the entire column you want to format, then right click and choose Format Cells from the context menu.
  2. In the Format Cells dialog, under the Number tab, select the Custom category.
  3. In the Type textbox type #.###, .
  4. Click OK.

enter image description here

Added:

If you actually want to change the numeric values you can divide all numbers by 1000 in another column and format those new calculated cells with a decimal point.

Related Question