# Thread: Insert decimal point (Excel 97)

1. ## Insert decimal point (Excel 97)

I've tried the HELP in Excel and tried searching the Lounge. I haven't had success. Maybe I am not wording the search correctly. I have a column of numbers. Example:
2210
2210
1100
1100
480
480
1110
1140
2210
These numbers are actually dollars amounts that need to be formatted as follows:
\$22.10
\$22.10
\$11.00
\$11.00
\$ 4.80
\$ 4.80
\$11.10
\$11.40
\$22.10

I have tried formatting as currency and custom formatting but I end up with a decimal point at the right side and more zeros to the right. Hopefully someone may have a "simple" solution as I'm not into writing code. Thanks for looking.
<img src=/S/help.gif border=0 alt=help width=23 height=15>

2. ## Re: Insert decimal point (Excel 97)

A custom format of \$0"."00 will do the trick. You have to put the decimal point in quotes so XL knows that it's just text. HTH --Sam

3. ## Re: Insert decimal point (Excel 97)

Hi,
If you only want to format them, then following Sam's suggestions will do it. If you actually wanted to convert them, enter 0.01 in an empty cell, copy it, select your column of numbers and choose Edit-Paste Special and check the multiply box. This will divide all your numbers by 100 and you can then format them as currency.
Hope that helps.

4. ## Re: Insert decimal point (Excel 97)

Thank you, Thank you, Thank you.
I was sure there was a way to do it but with very little knowledge of formulas and formatting I was at a loss. You have saved me hours of experimenting. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> <img src=/S/joy.gif border=0 alt=joy width=23 height=23> <img src=/S/joy.gif border=0 alt=joy width=23 height=23>

5. ## Re: Insert decimal point (Excel 97)

> wanted to convert them
Rory, that is too cool! Even works for formulas by changing the formula! I learned something today, guess I can go home! <img src=/S/wink.gif border=0 alt=wink width=15 height=15>

6. ## Re: Insert decimal point (Excel 97)

No fair - I'm working at home, so does that mean I have to go to the office?? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

7. ## Re: Insert decimal point (Excel 97)

Only if you need the rest! <img src=/S/snore.gif border=0 alt=snore width=32 height=15>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•