Ryan Case

Posts: n/a

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Automatic formatting problem in Excel	Hook	Excel Worksheet Functions	2	January 14th 05 07:15 PM
conditional formatting question	chris	Excel Worksheet Functions	2	January 5th 05 03:51 PM
Defining a number in a cell by text then subtracting it by the tex	Crowraine	Excel Worksheet Functions	1	December 16th 04 07:49 AM
Formatting a cell as "text" in the number catagory.	Ed	Excel Worksheet Functions	3	December 7th 04 07:12 PM
Area Chart Formatting Question	Avrilon	Charts and Charting in Excel	3	December 2nd 04 09:14 PM

All times are GMT +1. The time now is 11:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us