delimited file format issue

[evilyn]

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

 

[Pete_UK]

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

 

[evilyn]

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