Reformatting numbers in cells
 

We have a report which is printed without commas in the numbers but with a
preceding number and a slash. For example,
09/834602. The users would like the "834602" to read "834,602" but I can't
figure out how to do this because of the presence of the 09/. I am VERY new
to this. Thank you very much for your help.

Reformatting numbers in cells
 

=LEFT(C1,FIND("/",C1))&TEXT(--(MID(C1,FIND("/",C1)+1,99)),"#,##0")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Joanne" wrote in message
...
We have a report which is printed without commas in the numbers but with a
preceding number and a slash. For example,
09/834602. The users would like the "834602" to read "834,602" but I
can't
figure out how to do this because of the presence of the 09/. I am VERY
new
to this. Thank you very much for your help.