| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format for Whole number and 1 Decimal in same Cell
How can I format a cell, that if a value is entered as a whole number
it will appear as entered e.g 12, but if a decimal is entered into the same cell it will show to 1 decimal place e.g 12.356, will appear as 12.4. Note both could be typed into same cell Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom format whole number to decimal | Excel Worksheet Functions | |||
| Number format still uses decimal point | New Users to Excel | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
| I want to format a number cell without the decimal and without ro. | Excel Discussion (Misc queries) | |||
Threaded Mode
