Quick Excel help please
Author
Discussion

audi321

Original Poster:

6,206 posts

244 months

Tuesday 7th August 2018
quotequote all
Hi all, I have a csv file which has numbers in excess of 15 characters in it.

When I open the file, it doesn't display the entire number as it opens it in 'General' format.

I would normally change the format to 'text' before copy/paste into it, but with this file I can only 'open' it and the default is 'General' format which is too late to change to 'Text'.

Does anyone know a way around this? Thanks for any advice!

Doofus

34,722 posts

204 months

Tuesday 7th August 2018
quotequote all
audi321 said:
Hi all, I have a csv file which has numbers in excess of 15 characters in it.

When I open the file, it doesn't display the entire number as it opens it in 'General' format.

I would normally change the format to 'text' before copy/paste into it, but with this file I can only 'open' it and the default is 'General' format which is too late to change to 'Text'.

Does anyone know a way around this? Thanks for any advice!
If you can't edit the file (you say you can only open it), then Save As something else first, then change the format from General to Number, and make the cells wider.

Troubleatmill

10,210 posts

190 months

Tuesday 7th August 2018
quotequote all
edited


1/ Save as an Excel file.

2/ Change the format to NUMBER

3/ And then click the reduce decimal button twice

4/ Save again.

Alex

9,978 posts

315 months

Tuesday 7th August 2018
quotequote all
Don't open the CSV file directly in Excel. Instead:

1. Open Excel
2. Select Data->From Text
3. Follow the wizard and select Text as the format for the "big number" column

audi321

Original Poster:

6,206 posts

244 months

Tuesday 7th August 2018
quotequote all
Alex said:
Don't open the CSV file directly in Excel. Instead:

1. Open Excel
2. Select Data->From Text
3. Follow the wizard and select Text as the format for the "big number" column
Perfect thanks! You get the virtual beer tokens!