Simple Question

[estieb]

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

 

[mudraker]

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

 

[Bob Phillips]

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)