Hi, I could import some numbers from notepad to excel 2010, and after right click the cells were converted to General from scientific format. However, when I drag the notepad file to Excel 2013 they cannot be converted to General format. I tried different ways to convert them from text to numbers but they dont work. Even there is no Error button next to the cells to convert them to numbers. What is the way in Excel 2013 to have numbers format when the values are imported from text file?
The numbers you supply are in scientific format and hence have lost their significant digits. Hence there's no way of getting back to the original number without importing the numbers as numbers or general.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
=A2+0 copy across and down....
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi,
You can convert text to numbers using the Paste Special dialog. See:
http://spreadsheets.about.com/od/exc...cial.htm#step3
You can copy a zero and paste special using addition over your text or copy a one and paste special using multiplication over you text.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
With the same numbers I didn't have problem with Excel 2010.Originally Posted by Richard Buttrey
I tried this way but it gives "VALUE" and no error button to convert it to numbers. Please see attached file.
I did it but it doesnt work, please see the new attached file.
Last edited by relabz; 11-02-2015 at 04:20 AM.
No file attached. I simply used the file attached in your first post, where it was OK.
Thanks, when I open your attached file it is ok, but when I save it in my computer it shows again VALUES in columns G and H! Do you know what the problem is?
Here is the attachment of your file saved (test2).
Odd. I'll power up a laptop which has 2013 on it in a moment or two.
Thank you, could you please tell me the result? I need to work on my data with Excel 2013, but couldn't find how to fix this problem.
They opened as the value error. Clciking on any of the cells brought up the correct result; which stayed OK after saving/closing/opening.
But It doesnt happen when I click on them. please find the attached pic.
OK. Let's change approach and use a formula to give you a number...
=--LEFT(C2,FIND("E",C2)-1)*10^--MID(C2,FIND("+",C2)+1,255)
Like this?
It was perfect when it left here... (which is also true of the Titanic and Belfast - where it was built).
According to your profile you are in "teh". There is a reason for putting something that means something there. Regional settings do differ... Where might "teh" be??? Tehran?? Somewhere else?? Do you use ; instead of , as separators?
Even if I enter a number manually it saves it as date and the number format shows Custom, and after choosing General it changes to something else. for example in this image I entered 5.84.
Thanks, finally it is because of separator, when I enter 5,6 (instead of 5.6) it works and doesn't change to date or something else. Now how can I change settings for separator? I mean I want to have numbers from imported text files which have (.) as separators and have numbers in my excel file with (,) as separator.
PS by default it is (,)
Last edited by relabz; 11-02-2015 at 07:05 AM.
Thanks Glenn for your help.
I changed the Decimal Symbol to (.) from comma (,) in Control Panel > Region and language > Additional settings > Numbers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks