Hi,

First, there is no $ function. If you enter $556 all you are doing is
telling Excel that you want to use Currency notation.

To just be silly, here is another approach to the ones previously suggested:

1. In an empty cell enter 0.01
2. Copy that cell
3. Highlight all the cells you want to modify and choose
4. Edit, Paste Special, Multiply

For some value added for this post - note you do not need to click the
option button beside Multiply and then click OK, instead double-click the
word Multiply. This will select Multiply AND execute the command. A general
trick in Excel (only).

In 2007 the shortcut key for Paste Special is Ctrl+Alt+V

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Davie B1" wrote:

I entered a number on my worksheet using the $ function. I should have used
the format, cell, currency command. I have enter numbers like $665 and now
want to change all of these to show two decimal places such as $6.65. How do
I change all my numbers I have entered this way without going back and
changing each one individually . Thank you. Dave