Excel 2002

Excel >> Excel 2002

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

Excel89

Excel >> Excel 2002 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

> 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
>

Excel >> Excel 2002 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

> 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
>

>
>

>> 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
>>
>
>

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

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> 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
>
>

> > 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
> >

> >
> >

> >> 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
> >>
> >
> >
>
>

Excel >> Excel 2002 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

>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
>
>

>> 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
>>

>>
>>

>>> 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
>>>
>>
>>
>
>

Excel >> Excel 2002 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

> <<<"Change all occurrences ... at the same time">>>
>
> Did you select *all* the pertinent cells *before* you clicked on <Format>
> <Cells>?
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------

>> 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
>>
>>

>> > 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
>> >

>> >
>> >

>> >> 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
>> >>
>> >
>> >
>>
>>
>

Excel >> Excel 2002 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
>

>
>

>>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
>>
>>

>>> 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
>>>

>>>
>>>

>>>> 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
>>>>
>>>
>>>
>>
>>
>
>

Excel >> Excel 2002 Hi

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

--
Regards

Roger Govier

>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
>>

>>
>>

>>>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
>>>
>>>

>>>> 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
>>>>

>>>>
>>>>

>>>>> 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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Excel >> Excel 2002 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

> Hi
>
> Maybe click a blank cell, double click the format painter, "paint" over
> the relevant cells, press Escape.
>
> --
> Regards
>
> Roger Govier
>
>

>>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
>>>

>>>
>>>

>>>>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
>>>>
>>>>

>>>>> 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
>>>>>

>>>>>
>>>>>

>>>>>> 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
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Excel >> Excel 2002
> 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
>
>
>

>
>>Hi
>>
>>Maybe click a blank cell, double click the format painter, "paint" over
>>the relevant cells, press Escape.
>>
>>--
>>Regards
>>
>>Roger Govier
>>
>>

>>
>>>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
>>>>

>>>>
>>>>

>>>>
>>>>>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
>>>>>
>>>>>

>>>>>
>>>>>>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
>>>>>>

>>>>>>
>>>>>>

>>>>>>
>>>>>>>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

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