| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
number formatting question
I have csv files from another program that I want to bring into excel.
One of the columns contains mixed numbers in the format of 15.3/16. I want to have this changed to 15.1875. Any help is greatly appreciated. Ryan |
|
#2
|
|||
|
|||
|
Hi Ryan,
Change period to space using Ctrl+H then format as General or other number format of your choice, which might be #,###.0000 --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ryan Case" wrote in message ... I have csv files from another program that I want to bring into excel. One of the columns contains mixed numbers in the format of 15.3/16. I want to have this changed to 15.1875. Any help is greatly appreciated. Ryan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic formatting problem in Excel | Excel Worksheet Functions | |||
| conditional formatting question | Excel Worksheet Functions | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
| Area Chart Formatting Question | Charts and Charting in Excel | |||
Linear Mode
