I got a list of numbers and added +263 to the front of it.
I then saved it as a Microsoft Excel Comma Separated Values File (.csv) so I could then send the file to my cell phone and import the numbers into my phone book.
When I opened the file to check it the number format has changed and I have no idea to change it to the format I need!
Excel's default is to open CSV files and interpret them immediately. Consequently, to Excel +263715698499 is a number with a plus-sign prefix...so therefore, a number.
If you want to be able to set data types upon opening a CSV file:
• Data.From_text_file
...select your CSV file...Click: Import
...Follow the prompts in the import windows.
...on the 3rd window: Check: Text <-so Excel will format the values as text, retaining and displaying the leading plus-signs.
Is that something you can work with?
Last edited by Ron Coderre; 03-20-2016 at 03:11 PM.
I think that it has to do with the width of the columns of Excel when you open the file. The width is too small to accommodate the data so translates that value into the shorter scientific notation.
If you change the CSV extension to TXT and open with Notepad or other text editor, you will see the numbers as you entered them.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
I am trying to follow the instructions you sent me.Originally Posted by Ron Coderre
I don't know where or how to import the file from. I have opened Excel and gone to the file via open but cant find how to import. Sorry
From the Excel ribbon:
• Data.From_text
...navigat to your CSV file and select it
...Click: Import
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks