|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 28th, 2004, 09:29 AM
|
|||
|
|||
I don't want excell to change ratios to fractions, what to do?
How can I change excell settings so that it doesn't automatically change
ratios into decimals? example: When 1:263 is entered into a cell, it is displayed as 0.224305556 I want 1:263 to stay displayed as 1:263 in the cell after it is entered. What do I do? 
|
|
#2
September 28th, 2004, 11:17 AM
|
|||
|
|||
|
Format the cells as text
-- HTH RP "Nick" wrote in message ... How can I change excell settings so that it doesn't automatically change ratios into decimals? example: When 1:263 is entered into a cell, it is displayed as 0.224305556 I want 1:263 to stay displayed as 1:263 in the cell after it is entered. What do I do?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I Change recurrence settings with OUT updating details???? | Shawn Anderson | Calendar | 3 | September 20th, 2004 06:38 PM |
| How can I Change recurrence settings with OUT updating details???? | Shawn Anderson | General Discussion | 3 | September 20th, 2004 06:38 PM |
| How do I change data in one cell so other copies& vice versa | sedain | New Users | 3 | September 8th, 2004 10:07 PM |
| Change default message form | Paul Walley | Contacts | 1 | September 7th, 2004 04:24 AM |
| Set up master sheet to calculate derivative(rate of change) | Roger Govier | Setting up and Configuration | 0 | January 29th, 2004 03:31 PM |
Linear Mode
