Quick Excel help please
Discussion
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!
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!
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.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!
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


