This is a very simple question, however, I cannot seem to find th
answer. If a single cell contains the following:

2($333,333)

does excel have the ability for me to reference the leading digit, an
the monetary digit separately? Or do I have to split the leading digi
and monetary digit into their own cell?

Thanks
Eri

--
Message posted from http://www.ExcelForum.com

estieb

To answer your question completly we need more info as to what what yo
want excel to do with data

If you are using it in a formula then you can use left & mid function

--
Message posted from http://www.ExcelForum.com

Leading digit

=LEFT(A1,1)

Currency digit

=MID(A1,FIND("(",A1)+1,1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"estieb " wrote in message
...
This is a very simple question, however, I cannot seem to find the
answer. If a single cell contains the following:

2($333,333)

does excel have the ability for me to reference the leading digit, and
the monetary digit separately? Or do I have to split the leading digit
and monetary digit into their own cell?

Thanks
Eric


---
Message posted from http://www.ExcelForum.com/