Re: [NF] Excel Question
How about using the right function, such as: =RIGHT(E18,3) + 2 Bryant Minard Medford Software House 25 Ark Rd Medford, NJ 08055 Tel. (609) 654-5443Fax. (609) 654-5686 sa...@medfordsh.com > > > > > > > Paul Hill wrote: > > > > On Tue, Jun 8, 2010 at 7:47 PM, Jeff Johnson wrote: > > > I have a spreadsheet that has numbers entered in cells as '325. I want > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > j...@san-dc.com > > > www.san-dc.com > > > > > --- StripMime Report -- processed MIME parts --- > text/html (html body -- converted) > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/911acd39-1064-4b42-a4dd-da3b3895f...@me.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Excel Question
try =VALUE(Cell with '325). IE Cell A1 = '325, Cell A2 =VALUE(A1), THE RESULT A number 325 is in cell A2 Jim -Original Message- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Tuesday, June 08, 2010 5:12 PM To: profox@leafe.com Subject: Re: [NF] Excel Question Jeff Johnson wrote: > http://www.ambience.sk/old/open-office-text-number-format-conversion > > It uses search and replace with regular expressions .* and &. > > Not bad. > > Yikes! I can do this in Open Office but not in Excel. I am giving instructions to a client. They don't have Open Office. -- Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/01cb07ca$6931a300$3b94e9...@net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
On 08/06/10 16:05, Paul Hill wrote: > On Tue, Jun 8, 2010 at 7:47 PM, Jeff Johnson wrote: > >> I have a spreadsheet that has numbers entered in cells as '325. I want >> to convert them to 325 so I can operate on them. I can't figure out how >> to do this. If I convert the cell format to a number it doesn't work >> because it is text because of the single quote. >> > In the next row enter a formula like "=A1+0" > > e.g. > > A B > 1 '325 =A1+0 > 2 '100 =A2+0 > 3 '201 =A3+0 > > You can now work on the B column. > > Or copy values from B to A, delete B and then you've repaired your worksheet. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4c0ee6fe.9080...@gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
Jeff Johnson wrote: > http://www.ambience.sk/old/open-office-text-number-format-conversion > > It uses search and replace with regular expressions .* and &. > > Not bad. > > Yikes! I can do this in Open Office but not in Excel. I am giving instructions to a client. They don't have Open Office. -- Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4c0eb211.6070...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
Stephen Russell wrote: On Tue, Jun 8, 2010 at 2:43 PM, Jeff Johnson wrote: http://www.ambience.sk/old/open-office-text-number-format-conversion - -- j...@san-dc.com www.san-dc.com --- StripMime Report -- processed MIME parts --- text/html (html body -- converted) --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4c0eab30.8050...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
On Tue, Jun 8, 2010 at 2:43 PM, Jeff Johnson wrote: > http://www.ambience.sk/old/open-office-text-number-format-conversion > > It uses search and replace with regular expressions .* and &. - In OO can you use the spreadsheet to access outside data like ODBC source? I was trying to do that and could not find the hook to get access to the data. Or is it not there and that is the reason I couldn't find it? -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/aanlktinmy3-t7vhbriuxcg5evgxu_cbhnx4odafar...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
http://www.ambience.sk/old/open-office-text-number-format-conversion It uses search and replace with regular expressions .* and &. Not bad. -- Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4c0e9d67.5090...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
Paul Hill wrote: On Tue, Jun 8, 2010 at 7:47 PM, Jeff Johnson wrote: I have a spreadsheet that has numbers entered in cells as '325. I want -- j...@san-dc.com www.san-dc.com --- StripMime Report -- processed MIME parts --- text/html (html body -- converted) --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4c0e9523.2090...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
On Tue, Jun 8, 2010 at 7:47 PM, Jeff Johnson wrote: > I have a spreadsheet that has numbers entered in cells as '325. I want > to convert them to 325 so I can operate on them. I can't figure out how > to do this. If I convert the cell format to a number it doesn't work > because it is text because of the single quote. In the next row enter a formula like "=A1+0" e.g. A B 1 '325 =A1+0 2 '100 =A2+0 3 '201 =A3+0 You can now work on the B column. -- Paul ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/aanlktin0f98lbauqnf-b8rjhlzm5tdhh1zqnjqfa6...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
Jeff Johnson wrote: > > > > > Jarvis, Matthew wrote: > > > > > -Original Message- > profoxtech-boun...@leafe.com > > > [mailto:profoxtech-boun...@leafe.com] > > > On Behalf Of Jeff Johnson > > profoxt...@leafe.com > > > > > > want > > > to convert them to 325 so I can operate on them. I can't figure out > > > how > > > to do this. If I convert the cell format to a number it doesn't work > > > Excel 2003 does the same thing. -- Jeff --- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4c0e9480.6040...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: [NF] Excel Question
Jarvis, Matthew wrote: -Original Message- profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson profoxt...@leafe.com want to convert them to 325 so I can operate on them. I can't figure out how to do this. If I convert the cell format to a number it doesn't work ProFox@leafe.com http://leafe.com/mailman/listinfo/profox http://leafe.com/mailman/listinfo/profoxtech http://leafe.com/archives/search/profox http://leafe.com/archives/byMID/profox/69f310c05dd83c48a84ba3769ce1ecf8034ad...@tntriexevs02.triadhospitals.net http://leafe.com/reportAbuse/69f310c05dd83c48a84ba3769ce1ecf8034ad...@tntriexevs02.triadhospitals.net -- j...@san-dc.com www.san-dc.com --- StripMime Report -- processed MIME parts --- text/html (html body -- converted) --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4c0e9288.8090...@san-dc.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: [NF] Excel Question
> -Original Message- > From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] > On Behalf Of Jeff Johnson > Sent: Tuesday, June 08, 2010 11:48 AM > To: profoxt...@leafe.com > Subject: [NF] Excel Question > > I have a spreadsheet that has numbers entered in cells as '325. I want > to convert them to 325 so I can operate on them. I can't figure out how > to do this. If I convert the cell format to a number it doesn't work > because it is text because of the single quote. > > TIA > > -- > Jeff What version of Excel are you using? I've got 2003 and it seems to do math on the cells (summation, division, etc.) just fine... Maybe it's a setting somewhere in Options rather than a formatting thing? Thanks, Matthew Jarvis || Business Systems Analyst IT Department McKenzie-Willamette Medical Center 1460 G Street, Springfield, OR 97477 || Ph: 541-744-6092 || Fax: 541-744-6145 -- Disclaimer: This electronic message may contain information that is Proprietary, Confidential, or legally privileged or protected. It is intended only for the use of the individual(s) and entity named in the message. If you are not an intended recipient of this message, please notify the sender immediately and delete the material from your computer. Do not deliver, distribute or copy this message and do not disclose its contents or take any action in reliance on the information it contains. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/69f310c05dd83c48a84ba3769ce1ecf8034ad...@tntriexevs02.triadhospitals.net ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
