| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Display ONLY fraction portion of number
Using Excel 97, SR2
In Lotus, could go =Frac(A1) This would strip off everything to left of decimal in cell A1. Does Excel have an equivalent? I've tried using custom number formats, but can't get that to do what I want. Thanks in advance. -- John F. Scholten |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| How do I multiply Column G Totals by a number and display the res. | Excel Discussion (Misc queries) | |||
| Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Threaded Mode
