Thread: [Solved] Adding a decimal point in an already existing column of numbers
View Single Post
 
Old 07-25-2019, 11:51 AM
wheddingsjr wheddingsjr is offline Windows 7 64bit Office 2016
Advanced Beginner
  
Join Date: Mar 2017
Posts: 76
wheddingsjr is on a distinguished road
Default 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
Reply With Quote