Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosum
After i extract my values from database and make it view through excel2007 and
when i do autosum on needed columns , it does not calculate but instead the formula stays, y is it so thanks max |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosum
The cells are probabbly still text. Two things to try
1) First check the formating of the cells. Click on one of the cells that was read from the databae and go to worksheet menu Forat - Cells - Number and check if text is selected. change Text to a "number format". 2) Check the cells to make sure a single quote is NOT in front of the numbers. Click on cell and then look at F(x) box at top of worksheet. Look for the single quote as first character. Yo can remove the single quote easily by using the worksheet menu Edit - REPLACE. then put the single quote in the TO box and nothing in the FROM box and press replace ALL. Not sue how you are getting the cells from the database. The problem may be simply the cells were formated as text before you imported the data. Simply changing the formating may solve he problem. "Max" wrote: After i extract my values from database and make it view through excel2007 and when i do autosum on needed columns , it does not calculate but instead the formula stays, y is it so thanks max |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosum
Check out the cell format.(it must be Text now) in which the formulas will
not work. Change the formula cell format to General...If that doesn't work copy a blank cell. Select the data fieldsRight click PasteSpecialAdd Click OK. Now try summing... If this post helps click Yes --------------- Jacob Skaria "Max" wrote: After i extract my values from database and make it view through excel2007 and when i do autosum on needed columns , it does not calculate but instead the formula stays, y is it so thanks max |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosum
Thanks for all your suggestions though can work on it now , will look at it
tomorrow but i shouldnt forget to Thanks , so writing response "Jacob Skaria" wrote: Check out the cell format.(it must be Text now) in which the formulas will not work. Change the formula cell format to General...If that doesn't work copy a blank cell. Select the data fieldsRight click PasteSpecialAdd Click OK. Now try summing... If this post helps click Yes --------------- Jacob Skaria "Max" wrote: After i extract my values from database and make it view through excel2007 and when i do autosum on needed columns , it does not calculate but instead the formula stays, y is it so thanks max |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How 2 sort an autosum total list after adding items 2 autosum item | Excel Discussion (Misc queries) | |||
autosum | Excel Discussion (Misc queries) | |||
autosum | Excel Discussion (Misc queries) | |||
AutoSum Help | Excel Worksheet Functions | |||
Getting value of an Autosum | Excel Programming |