| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to add symbol to number & still act as number in excel?
How do I add a symbol to a number in Excel and still have the number act as a
number? i.e., 15 + 72* = 15 is what I am getting. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to add symbol to number & still act as number in excel?
Click FORMAT in the menu and select CELLS and if necessary click the NUMBERS
tab. In the Category column, scroll to the bottom of the list and select custom, and beneath the Type field, locate the format #,##0.00 (if you want decimals) or #,##0 for no decimals. In the type field, to the right of the last character in the selected formatting mask enter "*" (Quote/Asterisk/Quote) and click OK. The numbers formatted with this custom format now display the asterisk as the last character, but the entry remains a value. -- Kevin Backmann "swinq" wrote: How do I add a symbol to a number in Excel and still have the number act as a number? i.e., 15 + 72* = 15 is what I am getting. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to add symbol to number & still act as number in excel?
This is a very good question.
Format Cells... Number Custom General"*" The reason it's a good question is tht you can use the same technique to add units to numbers: General" lbs" or General" volts" etc. -- Gary''s Student - gsnu200792 "swinq" wrote: How do I add a symbol to a number in Excel and still have the number act as a number? i.e., 15 + 72* = 15 is what I am getting. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to add symbol to number & still act as number in excel?
Thank you so much!! I've been going crazy!!
"Kevin B" wrote: Click FORMAT in the menu and select CELLS and if necessary click the NUMBERS tab. In the Category column, scroll to the bottom of the list and select custom, and beneath the Type field, locate the format #,##0.00 (if you want decimals) or #,##0 for no decimals. In the type field, to the right of the last character in the selected formatting mask enter "*" (Quote/Asterisk/Quote) and click OK. The numbers formatted with this custom format now display the asterisk as the last character, but the entry remains a value. -- Kevin Backmann "swinq" wrote: How do I add a symbol to a number in Excel and still have the number act as a number? i.e., 15 + 72* = 15 is what I am getting. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Symbol or text after number to used in sum | Excel Worksheet Functions | |||
| How do I create a custom number format in Excel using a symbol? | Excel Discussion (Misc queries) | |||
| How do i add the squared symbol to a number | Excel Discussion (Misc queries) | |||
| excel shouldnt need a symbol before the first number in an equati | Excel Worksheet Functions | |||
| List of Symbol and Character Number | Excel Discussion (Misc queries) | |||
Linear Mode
