random1970

I realise this is an old, old thread, but the solution to it, and many others like it, is [U]lose the mouse[/U]. Use keyboard shortcuts - CTRL - C to copy, CTRL - V to paste, instead.

[QUOTE=zteam777;1046730]I am trying to enter the following formula but I am coming up blank. Ok, I have excel 2007. I created a purchase order. On the purchase order I am trying to calculate multiple sales tax possibilities depending on which state I place in the State cell. The 3 cells …

[QUOTE=mistercow.pnoy;1033532]We figured it out. But someone elses take on it would be appreciated.[/QUOTE] The easiest option is to use the MID and COLUMN functions. I've attached a spreadsheet which shows how this is done, and explains it too.

I'm not sure if this will help (I'm not a programmer), but if you can specify formulas / formats when you input the data, Excel does have a FIXED(number,[decimals]) formula which allows you to specify the number of decimal places. e.g. FIXED(C4,4) would display the value in cell C4 to …

What you want to do isn't too hard if you learn to use the Transpose Formula. It's an array formula. To use your example, if you have a 1 x 19 table (1 row high, 19 columns wide) and you want to transpose it, select a 19 x 1 array …

Hi Birsha, Upper, Lower and Proper are the text converters in Excel, but you have to create a new column, where the results can be stored. Add a column to the right of the one you have. If you want title case, go to the cell next to the first …

Hi. Can't help you with the query without the file. On the file attachment bit, I had the same problem with a recent reply I posted. I got around it by .zipping the Excel file, as .zip files are accepted. If you .zip your file and attach with your reply …

Here's another option. It's a spin on Midimagic's solution, but doesn't require you to retype the values as text. It's pretty adaptable too, depending on what you need. To fix this, modify the Excel document. For example, if your data is in column C, you have your header in C1 …