Thread: formula bar
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default formula bar

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!
--
Gary's Student
gsnu200703


"Lulu" wrote:

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 ?