delimited file format issue

i get reports from (idx) a program that are delimited files.  the
columns are all fine but 1 and i can't figure it out.  its supposed to
be money and comes across as 11500.  in the original program (idx) it
would look like 115.00 and that is how i want it to look in excel.  i
tried the easy stuff like formatting and i keep getting 11500.00 or
1150.0  in my simple mind i thought it would be easy to move that
decimal but its not turning out that way.  i have thousands of line
items so doing it one by one is not the optimum solution.  any help is
appreciated.

excel 2003
os XP

0
rdlink (9)
11/6/2007 10:21:12 PM
excel.newusers 15348 articles. 2 followers. Follow

2 Replies
700 Views

Similar Articles

[PageSpeed] 39

You really want to divide all these numbers by 100 - formatting won't
affect the values. Put the number 100 in an empty cell somewhere, then
select that cell and click <copy>. Then highlight all the cells (or
columns) that you want to change and click on Edit | Paste Special |
Values (check) | Divide (check) | OK then <Esc>.

You can then delete the 100 from the first cell.

Hope this helps.

Pete

On Nov 6, 10:21 pm, evilyn <rdl...@charter.net> wrote:
> i get reports from (idx) a program that are delimited files.  the
> columns are all fine but 1 and i can't figure it out.  its supposed to
> be money and comes across as 11500.  in the original program (idx) it
> would look like 115.00 and that is how i want it to look in excel.  i
> tried the easy stuff like formatting and i keep getting 11500.00 or
> 1150.0  in my simple mind i thought it would be easy to move that
> decimal but its not turning out that way.  i have thousands of line
> items so doing it one by one is not the optimum solution.  any help is
> appreciated.
>
> excel 2003
> os XP


0
pashurst (2576)
11/7/2007 12:33:26 AM
On Nov 6, 7:33 pm, Pete_UK <pashu...@auditel.net> wrote:
> You really want to divide all these numbers by 100 - formatting won't
> affect the values. Put the number 100 in an empty cell somewhere, then
> select that cell and click <copy>. Then highlight all the cells (or
> columns) that you want to change and click on Edit | Paste Special |
> Values (check) | Divide (check) | OK then <Esc>.
>
> You can then delete the 100 from the first cell.
>
> Hope this helps.
>
> Pete
>
Pete, Thanks sooooo much that's awesome and it worked like a charm.
I'll add the step to the macro and voila!  Thanks so much for your
help.  E

0
rdlink (9)
11/7/2007 3:03:53 PM
Reply:

Similar Artilces: