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/000001cb07ca$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.