Reformatting numbers in cells

  • Thread starter Thread starter Joanne
  • Start date Start date
J

Joanne

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.
 
=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)
 
Back
Top