formula bar

L

Lulu

I'll try again. I am setting up a mail merge taking data from excel 2003 and
merging into a word document. How do I get a figure in a cell e.g. 234.50
which appears in the formula bar as 234.5 to show up in the word document as
234.50 ?
 
D

driller

try to increase the decimal <click decimal button> so it will appear in the
CELL as 234.50...u can try even with something like $1,234.50...
what you see in the CELL may be the same when you copy paste link that CELL
inside a word document
 
G

Gary''s Student

I am not sure if a problem exists.

if you place 123.5 in a cell and format it as having 2 decimal places, it
will appear in the cell as:
123.50

If you copy the cell and paste into a Word doc, it will paste in as
123.50
It should preserve the format in Word. In fact, I rely on this to get
as-formatted Excel values!
 
Top