Column Formatting

Hi Brian;

Since you don't specify your current update levels for Office or OS X that's
the place to start... Make sure that Office is fully updated to 12.2.1 &
that you've applied the 10.6.1 update to OS X. Repair disk permissions after
any updates -- and a restart doesn't hurt I recall a formatting issue of
a similar nature but it was corrected by one of the Office updates.

I'm not clear on either of the formatting examples you gave, though. If I
format for pounds there is no - between the sign & the value. Even if the
amount is a minus the - appears before the symbol, not after it. I've also
not ever seen the " in Excel number formatting, although the () can be used
to indicate a minus value rather than the dash. Can you be more explicit
with your description of what you've done to apply the formatting (one of
the standard options, a custom format, a Style?)?

Does this happen in all workbooks, all sheets, or just certain ones? What
file format are you saving in? Is this a file you created or did you receive
it from another source?

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 11/2/09 5:44 PM, in article 59b7fd40.-1 RemoveThis @webcrossing.caR9absDaxw,
"Brian_C_Thomas@officeformac.com" <Brian_C_Thomas RemoveThis @officeformac.com> wrote:

> Version: 2008
> Operating System: Mac OS X 10.6 (Snow Leopard)
> Processor: Intel
>
> Could anyone help me please. I have an excel spreadsheet and i format the
> colums with currency formats so that they appear as £-0.00. but when i re-open
> the file the formatting has changed to "(0.00) how can i fix this.