Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data from exported file read as text, when edited becomes a # (pic
Here's what I have - a set of data exported from a program, organized into
nice little cells. I need to calculate some totals based on these numbers, but excel comes up with 0. If I double click (to edit) any of these values, then press enter (without doing anything) then the text seems to be converted to a readable entry for the formula. I have to "edit" each cell to get it to do this. Here's an example: The highlighted entries I've double clicked to "edit" and pressed Enter on - these will add up. http://i4.photobucket.com/albums/y14...eConverted.jpg The highlighted entries here have yet to be "edited" - these will NOT add up (come to 00:00:00) http://i4.photobucket.com/albums/y14...se/TimeRaw.jpg When I do this: http://i4.photobucket.com/albums/y14...e/TimeEdit.jpg the time converts to a "readable" format for the formula. I can't do this to the 4,000 plus cells individually. How do I convert them? I *have* tried changing the format to each column to the proper time (the time format that says "37:30:55") |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data from exported file read as text, when edited becomes a # (pic
Copy a blank cell.
Keeping the copy; select the range of cells in your data Right clickPasteSpecialselect Add. and click OK Now try your formulas.. If this post helps click Yes --------------- Jacob Skaria "Jarod" wrote: Here's what I have - a set of data exported from a program, organized into nice little cells. I need to calculate some totals based on these numbers, but excel comes up with 0. If I double click (to edit) any of these values, then press enter (without doing anything) then the text seems to be converted to a readable entry for the formula. I have to "edit" each cell to get it to do this. Here's an example: The highlighted entries I've double clicked to "edit" and pressed Enter on - these will add up. http://i4.photobucket.com/albums/y14...eConverted.jpg The highlighted entries here have yet to be "edited" - these will NOT add up (come to 00:00:00) http://i4.photobucket.com/albums/y14...se/TimeRaw.jpg When I do this: http://i4.photobucket.com/albums/y14...e/TimeEdit.jpg the time converts to a "readable" format for the formula. I can't do this to the 4,000 plus cells individually. How do I convert them? I *have* tried changing the format to each column to the proper time (the time format that says "37:30:55") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exported file to WP as merge. Now is corrupt. Data lost. Help | Excel Worksheet Functions | |||
How can i allow my excel webpage to be edited and not read only | Excel Discussion (Misc queries) | |||
How do you save an excel file to be read as IBM-type text file ? | Excel Worksheet Functions | |||
Exported File truncating cell data after 255 characters | Excel Discussion (Misc queries) | |||
why are there quotes in my exported text file? | Excel Discussion (Misc queries) |