How do I format cells in Excel to make 175/5 read 175?

  • Thread starter Thread starter SJR4347
  • Start date Start date
S

SJR4347

I want to copy a list of numbers from a web site into a spreadsheet. The
numbers all have a / in them, and this copies to the spreadsheet. Example
195/5. I would like to be able to format the cells so that the numbers will
read 195 (losing the / and any digits after it. Using another column with a
formula that would do this will also work.

Thanks.
 
Formatting cannot do what you want, as you have text, not a number.

You can use:
=left(a1,3)
to display what you want.

If you want the result as a number, use:
=--left(a1,3)

Regards,
Fred
 
Back
Top