Excel 2002

C

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
 
C

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
 
R

Ragdyer

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

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

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

[email protected]
[email protected] with @tiscali.co.uk
 
C

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
 
R

Roger Govier

Hi

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

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
 
B

Bill Sharpe

C said:
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
Click to expand...

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
 
Top