Custom currency formats

[Bernard V Liengme]

Two questions.
1) I have two PC running Excel 2002, call them Old and New. I am phasing out
Old and it has Excel 2002 while New has Excel 2002 SR2. If on the Old
machine I use Format|Cells, Currency then the Symbol box includes Francs
(French). This and all the 'old' currencies of EU countries that have
adopted the euro are missing in Excel 2002 SR2 on the New machine. Did they
go with SR1 or SR2?

2) I know how to make a custom format for, say francs using #,##0.00 "F".
But in an experiment I took a file from Old with a cell displaying 123.56 F
and opened in New. It displayed the same. However, it had custom format of
#,##0.00 [$F-40C]. Can anyone explain the [...] part to me.

Many thanks
Bernard

 

[Dave Peterson]

I don't have and answer for #1, but Debra Dalgleish found this for the
numbering format:

Creating an international custom number format in Excel
http://office.microsoft.com/assistance/2002/articles/xlCreateIntrCustomNumber.aspx
(one line in your browser)

Two questions.
1) I have two PC running Excel 2002, call them Old and New. I am phasing out
Old and it has Excel 2002 while New has Excel 2002 SR2. If on the Old
machine I use Format|Cells, Currency then the Symbol box includes Francs
(French). This and all the 'old' currencies of EU countries that have
adopted the euro are missing in Excel 2002 SR2 on the New machine. Did they
go with SR1 or SR2?

2) I know how to make a custom format for, say francs using #,##0.00 "F".
But in an experiment I took a file from Old with a cell displaying 123.56 F
and opened in New. It displayed the same. However, it had custom format of
#,##0.00 [$F-40C]. Can anyone explain the [...] part to me.

Many thanks
Bernard