ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   formula bar (https://www.excelbanter.com/excel-discussion-misc-queries/128409-formula-bar.html)

Lulu

formula bar
 
My first time! Can anyone tell me if I have a number in a cell that ends in a
zero after the decimal point such as 234.50 what I can do to it so that it's
appearence in the formula bar is the same and not 234.5. I 'm actually doing
a mail merge and entering this amount into a word document but when I do the
merge it shows up as 234.5 instead of 234.50.

Dave Peterson

formula bar
 
I don't think there's anything you can do. And on top of that, I don't think it
would fix your mailmerge problem.

But this might...

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.



Lulu wrote:

My first time! Can anyone tell me if I have a number in a cell that ends in a
zero after the decimal point such as 234.50 what I can do to it so that it's
appearence in the formula bar is the same and not 234.5. I 'm actually doing
a mail merge and entering this amount into a word document but when I do the
merge it shows up as 234.5 instead of 234.50.


--

Dave Peterson


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com