Format Number
That worked. Thanks!!
-----Original Message-----
Just format an empty, unused cell to the currency format
that you wish to
use.
Enter 100 into this cell.
Right click in this cell and choose "Copy".
Now, select the imported data.
Right click in this selection and choose "PasteSpecial".
Click on "Divide", then OK.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all
may benefit!
==============================================
"Becky" wrote in
message
...
I have numbers that import into Excel and they come in
with the General format.
Example: 34350
The number is actually the amount of a check for $343.50
I need to be able to format the cells to show this format.
I have been trying to create a custom currency format and
have had no luck.
Can anyone help?
.
|