#1
|
|||
|
|||
Adding a decimal point in an already existing column of numbers
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 Last edited by wheddingsjr; 07-25-2019 at 11:52 AM. Reason: Cut and paste didnt work correctly |
#2
|
|||
|
|||
Sorry, the cut and paste did not work. Please see the attached examples
|
#3
|
||||
|
||||
try:
=LEFT(A2,3) & "." & MID(A2,4,100) copied down. |
#4
|
|||
|
|||
Thanks p45cal. That worked perfectly.
|
Thread Tools | |
Display Modes | |
|
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 |