delimited file format issue
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 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
|