Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Convert text to numbers in 2003 MS Word

09 Apr 2018   #1
huffman

Windows 7 Pro
 
 
Convert text to numbers in 2003 MS Word

I need to be able to convert text to numbers in 2003 Word.
Unfortunately I have what appears two types of information on a line such as:

Walmart 7.40

I just want to convert the 7.40 to a number.

Any help is appreciated.


My System SpecsSystem Spec
.
09 Apr 2018   #2
mrjimphelps

Linux Mint 18.2 xfce 64-bit (VMWare host) / Windows 8.1 Pro 32-bit (VMWare guest)
 
 

If you can find a pattern for the information, such as the number always being the last item in the cell, then you could use "Text to Columns" to separate the number from the text portion. I am assuming that all of the information in question is in one column. If not, then it would be very helpful to rearrange it in that way.

1. Make sure that the column to the right of the column with the data in it is empty. If necessary, add a blank column to the right of the column with the data in it.

2. Highlight the column with the data in it. Click Data / Text to Columns.

3. You now need to decide how to divide up the data. If there is always one space between the word and the number, then you can choose Delimited, then choose Space as your delimiter. If there are always eight characters/spaces to the left of the number, then you can choose Fixed Width. If necessary, do only some of the data at a time, in order to be able to group the data in patterns.

4. Work your way through the Text to Columns menus, until you are back in the spreadsheet. Your numbers should be in a column by themselves. You can then convert to numeric in one of two ways:

a. Highlight the numbers, then choose Currency (or Number) as your data type.
b. Highlight the numbers, then put in the following formula: =value() --> the cell range needs to be in the parentheses.
My System SpecsSystem Spec
09 May 2018   #3
Snick

Win 10 x64, Linux Lite, Win 7 x64, BlackArch, Kali, VMWare Workstation Player, OpenVPN
 
 

Hi huffman,

7.40 looks like a number to me. Convert to number?
if you mean converting string to number, vb script will work. Short tutorial
Converting Strings to Numbers

Nic
My System SpecsSystem Spec
.

Reply

 Convert text to numbers in 2003 MS Word




Thread Tools




Similar help and support threads
Thread Forum
Change DOC file association back to Word 2003, after Word 2016 install
Hello everyone Until yesterday, I had only Word 2003 and Word 2010 on my computer. When I double-clicked a DOC file, it would open it in Word 2003. When I double-clicked a DOCX file, it would attempt to open it in Word 2010. I could open a DOCX file in Word 2003 if I first ran Word 2003 by...
Microsoft Office
Creating consecutive numbers on tickets in Pub 2003
I am creating event tickets and would like to add consecutive #s for raffles. I started with a business card template. I tried to use the page #s in a footer, but each page of tickets carries the same # on all tickets. I am not very experienced in Publisher at all, and don't know how to...
Microsoft Office
Word 2013 and 2003 installed; default programs won't recognize 2003
I have Word 2003 and 2013 installed on my computer. Word 2013 can't edit files with custom XML elements, so I want to use 2003 to open them. However, whenever I double-click an XML file, it launches 2013. I tried to fix this by selecting "open with" and browsing for Word 2003. But whenever I do...
Microsoft Office
Word 2010 is opening my word 2003 attachments
I normally use Word 2003 for documents, although I use Outlook 2010. This morning I opened a Word 2010 document and after quite a while of some sort of an installation, I was able to open the Word 2010 document. I did not think too much of it, except that later I was sending an e-mail and attached...
Microsoft Office
How do I convert numbers to letters
Hello I have a simple request I wish to respond to the How do I convert numbers to letters via the Excel Thank you very much
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 18:38.
Twitter Facebook Google+