How to add Deceimal to numbers?

R

Rocky Lam

How do I add a deceimal point to a column of numbers?

For example

From this
7221732.299
7221732.297
7221732.295
7221732.285

To this



7221.732.299
7221.732.297
7221.732.295
7221.732.285


Thanks

Rocky
 
N

Nick Hodge

Rocky

I feel maybe the two questions you have on these groups are related?

If data is in A1 in B1 enter:

=LEFT(A1,4)&"."&MID(A1,5,7)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
R

RagDyeR

Since you mention numbers, you could try these custom formats:

####\.###.###
OR
####\.###.000
OR
0000\.000.000

Depending on exactly what numbers you're using.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Rocky Lam" <RockylamATyahooDOTcom> wrote in message
How do I add a deceimal point to a column of numbers?

For example

From this
7221732.299
7221732.297
7221732.295
7221732.285

To this



7221.732.299
7221.732.297
7221.732.295
7221.732.285


Thanks

Rocky
 
Top