| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number formats
Ron,
Got another question for you. Your formula,=INT(A2/1000)+MOD(A2,1000)/320, returns 106125 as 106.390625. Is it possible to format that as 106'12.5? I've been using =MID(A2,1,3)+(MID(A2,4,3)/320) Is there any advantage to using one formula or the other? Your number format works great but I still need it broken down for other functions. I would like it displayed as 106'12.5 but recognized by excel as 106.390625. Thanks -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200604/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| number of userdefined formats | Setting up and Configuration of Excel | |||
| Sumproduct with different number formats | Excel Discussion (Misc queries) | |||
| number formats default to 2 decimal points when entered so 24 bec. | Excel Discussion (Misc queries) | |||
| Conditional Number Formats | Excel Discussion (Misc queries) | |||
| number formats that allow you to format the appearance of negativ. | Charts and Charting in Excel | |||
Threaded Mode
