Search a cell that contains words and numbers and convert the numbers to metric

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Search a cell that contains words and numbers and convert the numbers to metric

#36

10-08-2014, 01:42 PM

macropod

Windows 7 64bit Search a cell that contains words and numbers and convert the numbers to metric

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,512

To omit the ^ symbols, you could change:

Code:

        .Characters(Start:=j, Length:=k).Font.Superscript = True
        j = j + k

to:

Code:

        .Characters(Start:=j, Length:=k).Font.Superscript = True
        .Characters(j, 1).Delete
        j = j + k - 1

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Words in my document were converted to numbers????	MikeD23	Word	1	08-26-2012 11:09 AM
can word convert numbers?	koolfire	Word	2	01-07-2012 02:12 PM
Convert numbers to a specific text string	francis	Excel	1	10-06-2011 01:43 PM
Numbers in Words	janak	Excel	2	12-19-2010 08:53 PM
Numbers Convert in word in MS Access	towhid	Office	0	08-19-2010 01:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:27 PM.