Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Using "Multiply by 1"
I am having an issue that is driving me crazy. I have always had a trick of
converting numbers in cells using the formula "*1". Example, if you have a zip code that leads with 0 and you need to get rid of the zero. If you enter =Zip Code *1, it would return a four digit zip code. This always worked for me in a number of ways. Now, I am having the weirdest thing happen. When I type in this formula, it works for the first cell but when I copy it down, it is only return the content of the first cell, even though the formula is updating to reflect the correct cell. Example if cell A1 = 05444 and in cell b1 I type =a1*1, b1 returns the value 5444 When I copy down the formula, the formula reads correctly in b2, but still returns the result 5444. Anyone have any idea what I'm talking about?? *1 was always my trick and now it's not working. I'm using Office/Excel 2007. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Using "Multiply by 1"
Press the F9 key -- your file is in manual calculation.
"A" wrote in message ... I am having an issue that is driving me crazy. I have always had a trick of converting numbers in cells using the formula "*1". Example, if you have a zip code that leads with 0 and you need to get rid of the zero. If you enter =Zip Code *1, it would return a four digit zip code. This always worked for me in a number of ways. Now, I am having the weirdest thing happen. When I type in this formula, it works for the first cell but when I copy it down, it is only return the content of the first cell, even though the formula is updating to reflect the correct cell. Example if cell A1 = 05444 and in cell b1 I type =a1*1, b1 returns the value 5444 When I copy down the formula, the formula reads correctly in b2, but still returns the result 5444. Anyone have any idea what I'm talking about?? *1 was always my trick and now it's not working. I'm using Office/Excel 2007. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Using "Multiply by 1"
Office Button/Excel Options/Formulas, select Automatic calculation.
"A" wrote in message ... I am having an issue that is driving me crazy. I have always had a trick of converting numbers in cells using the formula "*1". Example, if you have a zip code that leads with 0 and you need to get rid of the zero. If you enter =Zip Code *1, it would return a four digit zip code. This always worked for me in a number of ways. Now, I am having the weirdest thing happen. When I type in this formula, it works for the first cell but when I copy it down, it is only return the content of the first cell, even though the formula is updating to reflect the correct cell. Example if cell A1 = 05444 and in cell b1 I type =a1*1, b1 returns the value 5444 When I copy down the formula, the formula reads correctly in b2, but still returns the result 5444. Anyone have any idea what I'm talking about?? *1 was always my trick and now it's not working. I'm using Office/Excel 2007. Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Using "Multiply by 1"
Sounds like calculation mode is set to manual.
Change it to automatic in Excel Options. BTW.........you can change the text to numbers in multiple cells without the use of formulas. Format all to General. Copy an empty cell. Select the range to change and editpaste specialaddokesc. Gord Dibben MS Excel MVP On Wed, 10 Jun 2009 14:00:01 -0700, A wrote: I am having an issue that is driving me crazy. I have always had a trick of converting numbers in cells using the formula "*1". Example, if you have a zip code that leads with 0 and you need to get rid of the zero. If you enter =Zip Code *1, it would return a four digit zip code. This always worked for me in a number of ways. Now, I am having the weirdest thing happen. When I type in this formula, it works for the first cell but when I copy it down, it is only return the content of the first cell, even though the formula is updating to reflect the correct cell. Example if cell A1 = 05444 and in cell b1 I type =a1*1, b1 returns the value 5444 When I copy down the formula, the formula reads correctly in b2, but still returns the result 5444. Anyone have any idea what I'm talking about?? *1 was always my trick and now it's not working. I'm using Office/Excel 2007. Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Using "Multiply by 1"
Or just
Home tabCalculationCalculation modeAutomatic -- Regards Roger Govier "Bob Umlas" wrote in message ... Office Button/Excel Options/Formulas, select Automatic calculation. "A" wrote in message ... I am having an issue that is driving me crazy. I have always had a trick of converting numbers in cells using the formula "*1". Example, if you have a zip code that leads with 0 and you need to get rid of the zero. If you enter =Zip Code *1, it would return a four digit zip code. This always worked for me in a number of ways. Now, I am having the weirdest thing happen. When I type in this formula, it works for the first cell but when I copy it down, it is only return the content of the first cell, even though the formula is updating to reflect the correct cell. Example if cell A1 = 05444 and in cell b1 I type =a1*1, b1 returns the value 5444 When I copy down the formula, the formula reads correctly in b2, but still returns the result 5444. Anyone have any idea what I'm talking about?? *1 was always my trick and now it's not working. I'm using Office/Excel 2007. Thanks! |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Using "Multiply by 1"
THANK YOU SO MUCH! This was it. I don't understand why it switched to that
or what manual calculation is - but it was making me crazy. Much appreciated. "Bob Umlas" wrote: Office Button/Excel Options/Formulas, select Automatic calculation. "A" wrote in message ... I am having an issue that is driving me crazy. I have always had a trick of converting numbers in cells using the formula "*1". Example, if you have a zip code that leads with 0 and you need to get rid of the zero. If you enter =Zip Code *1, it would return a four digit zip code. This always worked for me in a number of ways. Now, I am having the weirdest thing happen. When I type in this formula, it works for the first cell but when I copy it down, it is only return the content of the first cell, even though the formula is updating to reflect the correct cell. Example if cell A1 = 05444 and in cell b1 I type =a1*1, b1 returns the value 5444 When I copy down the formula, the formula reads correctly in b2, but still returns the result 5444. Anyone have any idea what I'm talking about?? *1 was always my trick and now it's not working. I'm using Office/Excel 2007. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |