Hello. I have 11/22 in word document. I copy it into excel and I want to add the = so it becomes 11/22. The way it copies in is as a date. How can I make it a number? Thanks.
Hello. I have 11/22 in word document. I copy it into excel and I want to add the = so it becomes 11/22. The way it copies in is as a date. How can I make it a number? Thanks.
=TRIM(A1)+0 i think this will work??
or you can do below things.
1. Copy the original Data
2. Paste to Notepad
3. Change the Cell Properties to TEXT in Excel
4. Copy All from Notepad
5. Paste back to Excel.
Second trick will definitely work.
Last edited by shukla.ankur281190; 09-12-2015 at 07:47 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Another possibility is =month(A1)/Right(year(a1),2) suggested by Mr.Anant Jain.
Formula:Please Login or Register to view this content.
Last edited by shukla.ankur281190; 09-12-2015 at 08:52 AM.
This has often been one of my many irritations with Excel -- it's constant desire to convert a regular fraction to a date.
Sometimes, if you pre-format the cell as fraction, then it will work. I think this works better for hand entered fractions rather than copy-pasted fractions.
Is there an easy way to concatenate a "0 " to the front of your fraction (0 11/22)? As this looks nothing like a date, Excel will usually recognize that you mean a mixed number and enter it appropriately.
Originally Posted by shg
If you pre-format the destination cell(s) as a number and paste, Match Destination Formatting, the result will be a decimal value...11/22 becomes .5
If you pre-format the destination cell(s) as a fraction and paste, Match Destination Formatting, the result will be a reduced fraction....11/22 becomes 1/2
<---------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
NEwdoverman is moneeeeeey.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks