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

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
> 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

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)



"bodhi_haha" <(E-Mail Removed)> wrote in message
news:E49C473A-E536-46CB-9A1A-(E-Mail Removed)...
> 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

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.
--
Gary''s Student
gsnu200709


"bodhi_haha" 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
> 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

sam,

try this: http://office.microsoft.com/en-us/wo...164951033.aspx

pay attention to DDE

hth,

Jim

"bodhi_haha" <(E-Mail Removed)> wrote in message
news:E49C473A-E536-46CB-9A1A-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> sam,
>
> try this: http://office.microsoft.com/en-us/wo...164951033.aspx
>
> pay attention to DDE
>
> hth,
>
> Jim
>
> "bodhi_haha" <(E-Mail Removed)> wrote in message
> news:E49C473A-E536-46CB-9A1A-(E-Mail Removed)...
>> 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
>
>

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

"KC Rippstein" <kcrippsteinAThotmailDOTcom> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> sam,
>>
>> try this: http://office.microsoft.com/en-us/wo...164951033.aspx
>>
>> pay attention to DDE
>>
>> hth,
>>
>> Jim
>>
>> "bodhi_haha" <(E-Mail Removed)> wrote in message
>> news:E49C473A-E536-46CB-9A1A-(E-Mail Removed)...
>>> 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
>>
>>
>
>