| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Decimal numbers in Excel
Is there a way to separate and use the numbers, to the left of and to the
right of the decimal point in a single cell? I am trying to convert angles given in decimal form (i.e. 27.286ﾂｰ), to the older form of degrees, minutes and seconds (i.e. 27ﾂｰ1710), then store the degrees in one cell, the minutes in another cell, and the seconds in a third. I can make it work the OTHER way with multiplication and addition, because that doesnt require the SEPARATION of a number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| How can I sort mostly 3 decimal with some 4 decimal numbers | Excel Discussion (Misc queries) | |||
| How do I sum hours in Excel and convert to decimal numbers? | Excel Discussion (Misc queries) | |||
| How do I enter a decimal in a string of numbers in Excel? Example. | Excel Discussion (Misc queries) | |||
Threaded Mode
