Thread: formula bar
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default formula bar

=TEXT(A1,"#.00")
--
David Biddulph

"Lulu" wrote in message
...
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 ?