Format Number

B

Becky

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

RagDyer

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



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