Excel 2002

[C J]

On a practice test I was asked to: Change all occurrences of the Currency
cell format (for example, $5.01) to General at the same time. I tried using
Format/Cell from the menu bar and it would not let me. I have exalted all
logical tries. What would be another way to make this change?
Thanks,
CJ

 

[Sandy Mann]

What do you mean by

Format/Cell from the menu bar and it would not let me.

Is the Cells option grayed out? If so try unprotecting the sheet.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[C J]

I was trying to say that when I went to Format / Cells, the test replied by
saying, Answer Incorrect. And no, it was not grayed out. I also tried
Protection / Allow User To Edit Range and received, Answer Incorrect. I
tried about six options before it moved on to the next question. In essence,
I did not use the step(s) that the test was looking for. Thanks for your
reply
CJ

 

[Ragdyer]

<<<"Change all occurrences ... at the same time">>>

Did you select *all* the pertinent cells *before* you clicked on <Format>
<Cells>?

 

[Sandy Mann]

Did you select the range of cells that you wanted to re-format. If you did
then I have failed the test as well!

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[C J]

Thanks for your reply. There was a crosshair cursor(+) that I could not
change. On Excel 2003, the cursor will change so that you can click and
drag to highlight multiple cells. I could not highlight the cells and they
did not appear to be highlighted.
CJ

 

[C J]

I tried to.
CJ

Did you select the range of cells that you wanted to re-format. If you
did then I have failed the test as well!

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Roger Govier]

Hi

Maybe click a blank cell, double click the format painter, "paint" over
the relevant cells, press Escape.

 

[C J]

Tried that too. However, EUREKA! The steps that can be taken are: Replace
/ Find What: $. Across from this is a Format button with a drop down,
Choose, Format. Now go to Replace with: General. Across from here again is
another Format button with a drop down, choose Format. At the bottom click
on Replace All. I hope this is clear. Thanks to all.
CJ

 

[Bill Sharpe]

Tried that too. However, EUREKA! The steps that can be taken are: Replace
/ Find What: $. Across from this is a Format button with a drop down,
Choose, Format. Now go to Replace with: General. Across from here again is
another Format button with a drop down, choose Format. At the bottom click
on Replace All. I hope this is clear. Thanks to all.
CJ

I presume that convoluted approach works and satisfies the expected
answer on the test. However, most users would select the cells first,
then right click and format the cells, as others have suggested. If
there are many cells scattered all over the spreadsheet perhaps the
method the test makers support is the easiest. It certainly isn't the
most apparent one, though.

been there, done that on automated tests before...

Bill