Tech Support Guy Forums - View Profile: BettyAtKitchen

Visitor Messages

IMPORTANT! READ THIS FIRST!
This form is to write a personal message to another user. DO NOT ASK FOR TECH SUPPORT HERE. To ask your tech support question, please go to the forums or read our welcome guide for new members. Thanks for your cooperation!

Showing Visitor Messages 1 to 5 of 5

05-Sep-2008 01:18 PM
BettyAtKitchen

ok.. i will post a new thread and will wait for your reply. tnx
05-Sep-2008 01:15 PM
computerman29642

If you could, create a thread with a sample file attached.
- View Conversation
05-Sep-2008 01:06 PM
computerman29642

I will be more than happy to try.
- View Conversation
08-Jul-2008 04:07 PM
BettyAtKitchen

Concatenate Help

I need to merge contents of two cell. I have been using Concatenate. However, in this particular case, one column has dollar values and the other column has unit item... .such when the two columns are merged, it should look like this:

Price Per Unit
9.00 case -->9.00/case
9.80 case -->9.80/case
9.99 case -->9.99/case

however, the merge will drop the zero if there is no other number to the right of it.

my question is: how should the merge be done so that the zeros are kept after the merge. thanks.
04-Jun-2008 03:37 PM
BettyAtKitchen

I wonder what I did... I have been using Excel 2007. When I use formulas, Excel automatically calculates for me. Now, when I type, for example, "=2*25" then hit enter, nothing happens.

Any suggestion?