98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Re formatting
Re formatting
Resolved · Low Priority · Version 2010
Thu 29 May 2014, 16:45Delegate Pauline said...
Pauline has attended:
Excel Advanced course
Re formatting
How do I remove an inverted comma in front of a number eg '1614 in order to get the number only 1614
Fri 30 May 2014, 10:42Trainer Gary said...
RE: Re formatting
Hi Pauline
Thanks for getting in touch. You can convert cells that look like numbers into real numbers with the VALUE function.
If your data '1614 is in cell A1 you would write
=VALUE(A1)
You could then Copy - Paste Special - Values to remove the formula when you're finished.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Fri 30 May 2014, 10:54Delegate Pauline said...
RE: Re formatting
I had already tried this before by copying the no ( text format)and paste ( right click, paste and value only) .
and reformatting it to number but it doesn't work when you are comparing two nos ( when using V look up) ...Even tried reformatting the two columns which I am comparing in the look up but still doesn't work.
Fri 30 May 2014, 11:42
Edited on Fri 30 May 2014, 11:43Trainer Gary said...
RE: Re formatting
Hi Pauline
Thanks for your reply. The VALUE function will help make your VLOOKUPs work. I've attached a workbook to give you an idea of how it fits together.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
GF VALUE function.xlsxFri 6 Jun 2014: Automatically marked as resolved.
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:Customize the toolbar in Excel 2010You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please. |
