98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel+training+london - Copy / Paste Number Format
excel+training+london - Copy / Paste Number Format
Resolved · Low Priority · Version Standard
Jennifer has attended:
Excel Advanced course
Dreamweaver 8 Introduction course
Dreamweaver 8 Intermediate course
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Copy / Paste Number Format
Sometimes when I copy and past a column of numbers to another column the clipboard icon appears and i can click on it and select "convert text to numbers" or something like that. I want to do this, but Excel only asks sometimes! How do i get it to ask, or is these another way to convert text to number (ie so the string of numbers goes from right aligned to left aligned to show its a number)
I dont think just doing format "number" will work as these are NI numbers, not actual numbers.
I'm doing this to use the numbers in an index match formula as it wont recognise the match if it thinks the numbers are text.
Thanks
Jen
RE: Copy / Paste Number Format
Hi Jennifer
Thank you for your question.
I wonder if the following will help:
1. Type the number 1 into a blank cell.
2. Copy the cell you have typed '1' into.
3. Select the range of cells you wish to convert to numbers.
4. Go to Edit - Paste Special.
5. Under Operation, choose Multiply and click OK.
This should change convert the numbers in the selected cells from text to numbers.
I hope this works for you.
Amanda
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Toggle Formulas and ResultsCtrl + 'The key above Tab with the |