add a zero

[Guest]

Excel 2003. In a cell, I have a formula that computes sales tax and gives the
resulting tax amount. Example of resulting amounts are 1.67, 1.83, 1.40. In
the case of 1.40, excel is displaying 1.40 because I set the formatting for
two decimals. However, the actual figure is 1.4. I would like the actual
value of the cell to be 1.40. I need the trailing zero for a mail merge I
have set up with Word. When Word merges, it shows the tax as 1.4. I need it
to display 1.40. Any help greatly appreciated!

Thanks

Sam

 

[Pete_UK]

Perhaps if you round the result of your formula to 2 dp, i.e.:

=ROUND(your formula,2)

Alternatively, you could turn the value into text, like so:

=TEXT(your formula,"0,00")

Hope this helps.

Pete

 

[Bob Phillips]

Change your formula to output text, such as

=TEXT(A2-(A2/(1+8%)),"0.00")

where 8% is the rate

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

IF 1.4 is in A1 then:

=TEXT(A1,"0.00")
will give you 1.40, but this time as a genuine 4 character item.

 

[Jim]

sam,

try this: http://office.microsoft.com/en-us/word/HA011164951033.aspx

pay attention to DDE

hth,

Jim

 

[KC Rippstein]

Thanks so much for that link, Jim. What a brilliant article, written in a
very user-friendly format yet full of truly powerful tips.
- KC

 

[Jim]

you're very welcome, and thanks for the feedback.