Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format cells in Excel to make 175/5 read 175?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format cells in Excel to make 175/5 read 175?
Hi,
Select the column and go to Data Text to columns Delimited. Select / as the delimiter -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "SJR4347" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I format cells in Excel to make 175/5 read 175?
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 "SJR4347" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I make the print size larger to read on excel spreadsheet | Excel Discussion (Misc queries) | |||
How do I make an Excel 2007 file read-only? | Excel Discussion (Misc queries) | |||
Format cells to make zeros not appear,or be invisible on screen &p | Excel Discussion (Misc queries) | |||
Custom format cells - how to make it say < number | Excel Worksheet Functions | |||
Make excel open file without Read Only dialog | Excel Discussion (Misc queries) |