Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas do not recognize numbers
I am trying to find the average for a list of numbers. These numbers were pulled from a database, run through a mailmerge program and then given back to me. They look like normal numbers, and don't seem to have any odd formatting, but the AVERAGE function does not seem to see them, and returns a #DIV/0! error. When I click on the cells as if I am going to change the data, the numbers are suddenly recognized by the formula as if they have changed format somehow. Can anybody help? IS there some way I can change the format of these numbers, I don't want to have to double click on thousands of cells to miraculously change them to be recognized.... ???HELP -- lynnw ------------------------------------------------------------------------ lynnw's Profile: http://www.excelforum.com/member.php...o&userid=34769 View this thread: http://www.excelforum.com/showthread...hreadid=545306 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas do not recognize numbers
Hi Lynn,
Highlight the entire column. Go to Data Text to Columns... Click Next Next Finish Does that work? -- Ken Hudson "lynnw" wrote: I am trying to find the average for a list of numbers. These numbers were pulled from a database, run through a mailmerge program and then given back to me. They look like normal numbers, and don't seem to have any odd formatting, but the AVERAGE function does not seem to see them, and returns a #DIV/0! error. When I click on the cells as if I am going to change the data, the numbers are suddenly recognized by the formula as if they have changed format somehow. Can anybody help? IS there some way I can change the format of these numbers, I don't want to have to double click on thousands of cells to miraculously change them to be recognized.... ???HELP -- lynnw ------------------------------------------------------------------------ lynnw's Profile: http://www.excelforum.com/member.php...o&userid=34769 View this thread: http://www.excelforum.com/showthread...hreadid=545306 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why are 1/2 my numbers imported as text and the rest as numbers? | Excel Discussion (Misc queries) | |||
Data Validation using whole numbers from formulas | Excel Discussion (Misc queries) | |||
formulas to numbers | New Users to Excel | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
Formulas for telephone numbers: finding duplicates, autoformat | Excel Worksheet Functions |