After saving and closing a new workbook, when I opened it this morning
all of the $ dollar designations were changed to Euros.

Any idea what happened?

How do I do an "edit-replace" in 2007?

On Sat, 22 Mar 2008 05:27:22 -0700, Jason wrote:

After saving and closing a new workbook, when I opened it this morning
all of the $ dollar designations were changed to Euros.

Any idea what happened?

http://office.microsoft.com/en-us/ex...491511033.aspx gives a guide
for 2003 to 2007 menu equivalents, but it may be worth seeing whether
Control-H still works.
--
David Biddulph

"Jason" wrote in message
...
How do I do an "edit-replace" in 2007?

On Sat, 22 Mar 2008 05:27:22 -0700, Jason wrote:

After saving and closing a new workbook, when I opened it this morning
all of the $ dollar designations were changed to Euros.

Any idea what happened?

Ctrl +H works, but it won't let me replace the euro designation with a
$ sign. Every worksheet in the workbook changed over to Euros.
Sheesh.

On Sat, 22 Mar 2008 12:46:08 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

http://office.microsoft.com/en-us/ex...491511033.aspx gives a guide
for 2003 to 2007 menu equivalents, but it may be worth seeing whether
Control-H still works.

My guess is that you haven't got the Euro symbol as a text item, but as part
of your currency formatting.
May well be Windows Regional Options, otherwise in Excel look at Format/
Cells/ Currency.
--
David Biddulph

"Jason" wrote in message
...
Ctrl +H works, but it won't let me replace the euro designation with a
$ sign. Every worksheet in the workbook changed over to Euros.
Sheesh.

On Sat, 22 Mar 2008 12:46:08 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

http://office.microsoft.com/en-us/ex...491511033.aspx gives a guide
for 2003 to 2007 menu equivalents, but it may be worth seeing whether
Control-H still works.

This is insanity. I just changed everything on my new worksheet back
to $. I saved, closed the workbook, opened and now two of the columns
are back to euros. The time of day columns no less.

I HATE 2007.

On Sat, 22 Mar 2008 14:35:20 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

My guess is that you haven't got the Euro symbol as a text item, but as part
of your currency formatting.
May well be Windows Regional Options, otherwise in Excel look at Format/
Cells/ Currency.

And what do the settings in your Windows Regional Options (accessed via the
Windows Control Panel) say for currency display?
I'm rather confused by your reference to "time of day" columns? What is the
cell formatting of the cells affected? [What does it say when you go to
Format/ Cells/ Custom ?]
--
David Biddulph

"Jason" wrote in message
...
This is insanity. I just changed everything on my new worksheet back
to $. I saved, closed the workbook, opened and now two of the columns
are back to euros. The time of day columns no less.

I HATE 2007.

On Sat, 22 Mar 2008 14:35:20 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

My guess is that you haven't got the Euro symbol as a text item, but as
part
of your currency formatting.
May well be Windows Regional Options, otherwise in Excel look at Format/
Cells/ Currency.

Regional settings are for US currency.

I've never ever used Euros for anything.

Cell formatting is Time1:30 PM

On Sat, 22 Mar 2008 16:30:34 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

And what do the settings in your Windows Regional Options (accessed via the
Windows Control Panel) say for currency display?
I'm rather confused by your reference to "time of day" columns? What is the
cell formatting of the cells affected? [What does it say when you go to
Format/ Cells/ Custom ?]

Actually, I just changed my time settings for these columns again.

Custom h:mm AM/PM

This looks better. This way i shouldn't always have to enter AM or PM
when entering time.

OK. I just saved, and then opened and closed the workbook again, and
it ddidn't change everything to Euros.

But this is just for one worksheet in the workbook. My problem now is
to change back all of the Euro designations in the other 7 sheets in
my workbook.

Do you have any idea how I do that. I tried the replace feature, but
I can't get that to work. I must not know how to enter the Euro
symbol in there.

On Sat, 22 Mar 2008 16:30:34 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

And what do the settings in your Windows Regional Options (accessed via the
Windows Control Panel) say for currency display?
I'm rather confused by your reference to "time of day" columns? What is the
cell formatting of the cells affected? [What does it say when you go to
Format/ Cells/ Custom ?]

"Jason" wrote:

Regional settings are for US currency.
I've never ever used Euros for anything.

Actually, I just changed my time settings for these columns again.

Custom h:mm AM/PM

This looks better. This way i shouldn't always have to enter AM or PM
when entering time.

OK. I just saved, and then opened and closed the workbook again, and
it ddidn't change everything to Euros.

But this is just for one worksheet in the workbook. My problem now is
to change back all of the Euro designations in the other 7 sheets in
my workbook.

Hi,

I have the same kind of problem: I live in Finland (Europe) and use euros.
But when I save the workbook and re-open it, the currency symbol has changed
to dollars :-).

I guess this is just a Microsofts bug... sorry, an undocumented feature...

BR,

Vesa Linja-aho