Hello,

I am trying to figure out how to either write a macro that will take a cell
containing numeric values change them to text, then add spaces to display
values same as the French Canadian format, for example $99,090.01 to 99
090,01 $. I know this can be done in the International tab under options for
numeric values, but as soon as the workbook is opened in Excel-Mac it is
automatically changed back to English formatting. By changing these values
to text then adding the spaces to mimic the French format. Excel-Mac will
treat these cells as text and not modify them. Or is there some Excel command
which allows custom formatting of Text cells?

Help please.

=TEXT(H6,"#,##0.00 $")


Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 13:14:23 -0800, KDore@AIC
wrote:

Hello,

I am trying to figure out how to either write a macro that will take a cell
containing numeric values change them to text, then add spaces to display
values same as the French Canadian format, for example $99,090.01 to 99
090,01 $. I know this can be done in the International tab under options for
numeric values, but as soon as the workbook is opened in Excel-Mac it is
automatically changed back to English formatting. By changing these values
to text then adding the spaces to mimic the French format. Excel-Mac will
treat these cells as text and not modify them. Or is there some Excel command
which allows custom formatting of Text cells?

Help please.