Exponential?

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

My bank allows me to download my transactions to a CSV file.
Unfortunately one of the columns just has content such as 8.03E+11.
How do I get the actual content of that cell to display. I actually
need the last few digits. Making the cell wider does not help.
 
My bank allows me to download my transactions to a CSV file.
Unfortunately one of the columns just has content such as 8.03E+11.
How do I get the actual content of that cell to display. I actually
need the last few digits. Making the cell wider does not help.
Click to expand...

Do you have the cell/column formatted as Number with 2 decimal places? If
so, the entire number is in the cell, it is just your format that is hiding
it from you. Click on the cell with the number you mentioned, then look at
the formula bar... what is displayed there?

Rick
 
Do you have the cell/column formatted as Number with 2 decimal places? If
so, the entire number is in the cell, it is just your format that is hiding
it from you. Click on the cell with the number you mentioned, then look at
the formula bar... what is displayed there?

Rick
Click to expand...

Hi Rick
The cells should have a number such as 802548110002. What I am
actually getting, if I expand the column width, is 803E+11. If I place
the cursor on the cell, the formula bar displays 803000000000. The bit
I am actually interested in is the last two numbers (ie: 02 in the
above example, or whatever), the rest is not important.
Cheers
Max
 
Do you have the cell/column formatted as Number with 2 decimal places? If
so, the entire number is in the cell, it is just your format that is hiding
it from you. Click on the cell with the number you mentioned, then look at
the formula bar... what is displayed there?

Rick
Click to expand...

One other thing, It makes no difference when I format the cell to more
than two decimal places. I just get more Os after the 8.03.
Max
 
Hi Max

Save the downloaded file to you disk, then change it from a .csv to a
..txt file before trying to open in Excel.
This will cause the wizard Data Text to Columns to be invoked, choose

Delimited>Next>choose Comma as separator>Next>mark the column with your
Number and choose Text>Finish
 
Back
Top