Can't format numbers for France in Excel 2003

[Mary Fran]

I'm using the US version of Excel 2003, but need to format costs, etc., for a
project in the French euro format (e.g., I need 2050.45 euros to display as 2
050,45).

That currency format isn't offered in my dialog box, and if I make a custom
number format that will display correctly, it doesn't operate as a number.

Any suggestions?

 

[Ron Rosenfeld]

I'm using the US version of Excel 2003, but need to format costs, etc., for a
project in the French euro format (e.g., I need 2050.45 euros to display as 2
050,45).

That currency format isn't offered in my dialog box, and if I make a custom
number format that will display correctly, it doesn't operate as a number.

Any suggestions?

Try setting your Regional Settings to French (France).

(Start/Control Panel/Regional Settings)

When you set it up, check to see that the digit grouping settings is the <dot>.
--ron

 

[Niek Otten]

Hi Mary,

Tools>Options>International tab, uncheck "Use system separators" and choose your separators

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm using the US version of Excel 2003, but need to format costs, etc., for a
| project in the French euro format (e.g., I need 2050.45 euros to display as 2
| 050,45).
|
| That currency format isn't offered in my dialog box, and if I make a custom
| number format that will display correctly, it doesn't operate as a number.
|
| Any suggestions?