Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell Problem when opening file created in another application!!
good afernoon, I have a problem that is when I open a excell file created in
a accounting program it doesn´t allow me to make any calculation for instance, I would like to make a somatory from some cells but the only result tha I obtain is 0, I don´t understand why because the values are well formatted, everything should work fine but it doesn´t, can anyone help me please? My version of office is 2003 and the program from I created the excell file is PMR, a Portuguese accounting program. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell Problem when opening file created in another application!!
it really sounds like the numbers are formatted text. Make another column
next to the numbers and use the VALUE function to turn them into numbers, then sum that column, see if it works. "Zircum" wrote: good afernoon, I have a problem that is when I open a excell file created in a accounting program it doesn´t allow me to make any calculation for instance, I would like to make a somatory from some cells but the only result tha I obtain is 0, I don´t understand why because the values are well formatted, everything should work fine but it doesn´t, can anyone help me please? My version of office is 2003 and the program from I created the excell file is PMR, a Portuguese accounting program. Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell Problem when opening file created in another applicatio
I´ve made Like you said and it worked but the values imported still the same
way, doesn´t sum... The numbers I´ve already converted them to number, currency, general but with no positive results, I´m desperate hehehehe!! Thanks :) "dlw" escreveu: it really sounds like the numbers are formatted text. Make another column next to the numbers and use the VALUE function to turn them into numbers, then sum that column, see if it works. "Zircum" wrote: good afernoon, I have a problem that is when I open a excell file created in a accounting program it doesn´t allow me to make any calculation for instance, I would like to make a somatory from some cells but the only result tha I obtain is 0, I don´t understand why because the values are well formatted, everything should work fine but it doesn´t, can anyone help me please? My version of office is 2003 and the program from I created the excell file is PMR, a Portuguese accounting program. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy excell file to a CSV file and than to Notepad | Excel Discussion (Misc queries) | |||
Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
How do i sign a author name to an excell file that I created? | Excel Worksheet Functions | |||
opening file problem please help | Excel Discussion (Misc queries) | |||
File asks to update when no links were created | Links and Linking in Excel |