| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom format cells - how to make it say < number
Is this what you mean
[<0]<0.0;General -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "liniis" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom format cells - how to make it say < number
...do you mean that I should write this in the custom category in the "number" tab under "format cells"? I have tried that but excel returns a warning sayin that Excel cannot use the number format I typed. LMK... /Liniis -- liniis ------------------------------------------------------------------------ liniis's Profile: http://www.excelforum.com/member.php...o&userid=31615 View this thread: http://www.excelforum.com/showthread...hreadid=513105 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Custom format cells - how to make it say < number
I mean in the Custom selection of FormatCells
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "liniis" wrote in message ... ..do you mean that I should write this in the custom category in the "number" tab under "format cells"? I have tried that but excel returns a warning sayin that Excel cannot use the number format I typed. LMK... /Liniis -- liniis ------------------------------------------------------------------------ liniis's Profile: http://www.excelforum.com/member.php...o&userid=31615 View this thread: http://www.excelforum.com/showthread...hreadid=513105 |
| Reply |
| 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) | |||
Linear Mode
