View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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.