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
HIS


"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