Adding a decimal point in an already existing column of numbers

wheddingsjr · #1 07-25-2019, 11:51 AM

Hi all

I have a column of numbers that I want to add a decimal point after the third digit. is there a way to do that? I originally did a text to column and split the number where I wanted to, added a column with just the decimal point than concatonated the three columns. Unfortunately for me my boss pointed out the the preceeding zero's that should have been there were dropped when I split the number. (see below). Is there something I can do to prevent the zero's from dropping? Thanks in advance.

CODECODE2Z01020Z01.20Z01021Z01.21Z86002Z86.2Z86003Z86.3Z86004Z86.4Z86005Z86.5Z86006Z86.6Z86007Z86.7

wheddingsjr · #2 07-25-2019, 11:58 AM

Sorry, the cut and paste did not work. Please see the attached examples

p45cal · #3 07-25-2019, 03:16 PM

try:
=LEFT(A2,3) & "." & MID(A2,4,100)
copied down.

wheddingsjr · #4 07-26-2019, 07:41 AM

Thanks p45cal. That worked perfectly.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding range of numbers to column	AUBuck	Excel	2	07-20-2017 11:50 PM
How to create a decimal point after each number in a numbered list in excel	wondermuse	Excel	1	03-06-2017 03:42 AM
Pulling 2 digits before a decimal point from adjoining cell then zeros after decimal	jadess916	Excel	1	06-26-2014 03:48 AM
Align Mail Merged Numbers to the Decimal Point	HangMan	Mail Merge	1	12-11-2013 02:32 PM
Merge, Too many Numbers right of the Decimal Point	ohdearme	Mail Merge	0	10-25-2009 05:10 PM