Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display a digit before or after the decimal point in another cell
I want to be able to display the number that is so many spaces to the left
and right of the decimal point. Example: 1234.56 How do I put the second digit to the left of the decimal point (number 3) in a different cell in Excel? How do I put the first digit to the right of the decimal point (number 5) in a different cell in Excel? What function would I use? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 queries: Display last cell, and compare two lists | Excel Worksheet Functions | |||
MS Excel 2000 Cell Capacity and Data Display | Excel Discussion (Misc queries) | |||
have cell display the word balance when a equals the same amount a | Excel Discussion (Misc queries) | |||
How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
Display actual contents of cell | Excel Discussion (Misc queries) |