| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom format cells - how to make it say < number
Hi, I have a tiny question for you... You know that one can get for example the format "percent" in a cell so if I write 8, 8% will turn up in the cell. I would like to do the same but with < so if I write 0,1 the cell will say <0.1. The only number in the cell have to be 0.1 so I can use these numbers to make diagrams and calculate etc. I have looked at the custom category on Format Cells under Format but I can't come up with a format code that gives the wanted result. So please, can anyone give me help on this.... Thanks! /liniis -- liniis ------------------------------------------------------------------------ liniis's Profile: http://www.excelforum.com/member.php...o&userid=31615 View this thread: http://www.excelforum.com/showthread...hreadid=513105 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format a cell with a custom number format | Excel Worksheet Functions | |||
| Custom format for cells | Excel Discussion (Misc queries) | |||
| Custom Number format question | Excel Discussion (Misc queries) | |||
| how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
Threaded Mode
