Format number With "." Point

Aug 6, 2013 at 3:16 PM
Example in cell value 1565328

Requerid = 1.565.328

In Excel format cell Separated in miles AND 0 decimals
Aug 7, 2013 at 12:23 PM
FormatCode : '#,##0' (yes, a comma).
if the "." is'nt the thousand separator defined in regional settings : '###\.###\.##0' but you must adapt with the length of your number to avoid '..123'