Adding a decimal point in an already existing column of numbers

		Microsoft Office Forums > Microsoft Excel > Excel
Adding a decimal point in an already existing column of numbers

07-25-2019, 03:16 PM

p45cal

Windows 10 Adding a decimal point in an already existing column of numbers

Office 2016

Expert

Join Date: Apr 2014

Posts: 962

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:52 PM.