Prev: Spell check is not allowing ignore or changes on undo edit
Next: How to write personal letters US President searching for videomsn
From: Rohit on 20 Apr 2010 21:49
Q1 How can I insert comment in word
Q2 How can I format numbers in words. that is if enter 520935521 and i want
the numbers formatted as 520,935,521.
From: trip_to_tokyo on 21 Apr 2010 00:16
WORD 2007

To insert comment:-

Review / Comments group / New Comment

If my comments have helped please hit Yes.

Thanks.



"Rohit" wrote:

> Q1 How can I insert comment in word
> Q2 How can I format numbers in words. that is if enter 520935521 and i want
> the numbers formatted as 520,935,521.
From: Doug Robbins - Word MVP on 21 Apr 2010 00:36
Running a macro containing the following code will format all of the cells
that are selected in that way:

Dim numrange As Range, cellrange As Range
Dim i As Long
Set cellrange = Selection.Range
For i = 1 To cellrange.Cells.Count
Set numrange = cellrange.Cells(i).Range
numrange.End = numrange.End - 1
If IsNumeric(numrange.Text) Then
numrange.Text = Format(numrange.Text, "#,###")
End If
Next i

See the article "What do I do with macros sent to me by other newsgroup
readers to help me out?” at:
http://www.word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Rohit" <Rohit(a)discussions.microsoft.com> wrote in message
news:84F15976-A8E6-4603-A9C3-3DCD06B1F00B(a)microsoft.com...
> Q1 How can I insert comment in word
> Q2 How can I format numbers in words. that is if enter 520935521 and i
> want
> the numbers formatted as 520,935,521.

 | 
Pages: 1
Prev: Spell check is not allowing ignore or changes on undo edit
Next: How to write personal letters US President searching for videomsn