Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP PLEASE!!!!
I am working on a spreadsheet and when you "look" at the cell it looks like
this: 'S000000200BX00000001000 . I need to figure out how to do an auto sum on these. I was messing around and did a few find and replace and got rid of the 'S thing and now I have a formula that looks like this... 2E+13... what is going on with this crazy thing?? This is a spreadsheet that is not made with in my company and I am not sure of how it was created! ANY HELP IS GREATLY APPRECIATED!!! PLEASE!!!!!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula HELP PLEASE!!!!
Hi,
It looks like you are going the right way, sum can only be done on numbers, and you are converting the strings to numbers. What you have there is scientific notation for a number, in your case 2E+13 means a 2 followed by 13 zeros. The thing here is if that is the number you expected. If you can get back to the data origin, and they can explain to you what is on the data, you can extract the desired information with text formulas as RIGHT, MID and LEFT (check the help for each one, they are pretty easy) Hope this helps, Miguel. "DestinySky" wrote: I am working on a spreadsheet and when you "look" at the cell it looks like this: 'S000000200BX00000001000 . I need to figure out how to do an auto sum on these. I was messing around and did a few find and replace and got rid of the 'S thing and now I have a formula that looks like this... 2E+13... what is going on with this crazy thing?? This is a spreadsheet that is not made with in my company and I am not sure of how it was created! ANY HELP IS GREATLY APPRECIATED!!! PLEASE!!!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |