add a zero

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bodhi_haha - 07 Mar 2007 17:32 GMT

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

Reply to this Message

Pete_UK - 07 Mar 2007 17:43 GMT

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

On Mar 7, 5:32 pm, bodhi_haha <bodhi_h...@discussions.microsoft.com>
wrote:

> 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
[quoted text clipped - 7 lines]
>
> Sam

Reply to this Message

Bob Phillips - 07 Mar 2007 17:54 GMT

Change your formula to output text, such as

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

where 8% is the rate

Signature

---
HTH

Bob

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

> Excel 2003. In a cell, I have a formula that computes sales tax and gives
> the
[quoted text clipped - 11 lines]
>
> Sam

Reply to this Message

Gary''s Student - 07 Mar 2007 18:00 GMT

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.

Signature

Gary''s Student
gsnu200709

> 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
[quoted text clipped - 7 lines]
>
> Sam

Reply to this Message

Jim - 08 Mar 2007 02:37 GMT

sam,

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

pay attention to DDE

hth,

Jim

> Excel 2003. In a cell, I have a formula that computes sales tax and gives
> the
[quoted text clipped - 11 lines]
>
> Sam

Reply to this Message

KC Rippstein - 08 Mar 2007 13:52 GMT

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

> sam,
>
[quoted text clipped - 21 lines]
>>
>> Sam

Reply to this Message

Jim - 09 Mar 2007 05:37 GMT

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

> Thanks so much for that link, Jim. What a brilliant article, written in a
> very user-friendly format yet full of truly powerful tips.
[quoted text clipped - 26 lines]
>>>
>>> Sam

Reply to this Message