I am in the UK, I have been asked by a friend in France (who is a
translator) how he can arrange for his French version of Excel 2007 to show
numbers in the standard English nnn.nn format as against the standard French
nnn,nn format to which his PC defaults. He and I are both using Windows XP.

We know about changing the Language/Regional setting in Control Panel which
can do it locally, but he needs a way to change the settings within the
Excel file so that when it is opened by his client, who will have the French
version of Windows and Excel, it is still in nnn.nn and does not go back to
nnn,nn.

I have been experimenting on my English Language PC trying to go from UK
format to French, and I have tried to change it using the Format Cells
feature, updating the <Number<Custom part, but I have got nowhere.

Can anyone help please?

OK then, let me ask the same question in a totally different way.

In the Excel file located at
http://myweb.tiscali.co.uk/albertd/F...%20problem.xls how can I
arrange for it to do what is described in the two blocks of text in the
"English" and "French" sheets?