formula bar
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 ? |
formula bar
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 -- ***** birds of the same feather flock together.. "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 ? |
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 ? |
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 ? |
All times are GMT +1. The time now is 04:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com