Adding Periods at Specified intervals
Custom Format 0000"."00"."0000
Gord
On Wed, 11 Apr 2012 17:13:46 +0000, ddefina
wrote:
Hi,
I have an excel problem that I've been working on for a few minutes, and
thought perhaps someone here knows a good formula to simplify my work.
I have a column of 10 digit numbers. In each number, periods have to be
added at intervals of 4, 2, and 4 digits. For example, if the number is
1234567890, than it needs to be broken down to, 1234.56.7890
Does anyone know an easy way to do this? I thought it might be a matter
of recording a macro to divide the numbers into columns, add the the
periods, than combine them back into an output column, but I'm sure
there has to be an easier way. Thanks!
|