Grid - Pre Sale Questions
Thousands Separator
Thread Starter: Pack Started: 3/23/2008 10:25 PM UTC
Replies: 2
Thousands Separator
In the Spanish format "10.000" is ten thousand. If I I copy and paste this text in another cell, the "." disappears. How can I ensure the format is not lost or, even better, that a string containing numbers is formatted as a number, but with the Spanish format? Thanks.

Re: Thousands Separator

Sorry for asking too early. Looping through all cells and writing

Cells[cn,rn].Format:='0,000.00';

seems to do the trick



 

Re: Thousands Separator
Rather: Cells[cn,rn].Format:='#,###'