| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i put a addition sign before a digit in the cell box?
Could u please help me out on this...
|
|
#2
|
|||
|
|||
|
you will need to put a single quote in front of the number, treating it as
text. Cell A1 = '+6 Excel will convert it back to a number if you use it in a calculation such as =A1 + 5 wil return 11. Also you can convert it to a number for any formulas by using =Value(a1). "Anns" wrote: Could u please help me out on this... |
|
#3
|
|||
|
|||
|
You could try a custom format of +General;General
-- HTH Bob Phillips "Anns" wrote in message ... Could u please help me out on this... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 16th digit changes?? Problem,16th digit changes to a zero.... | Excel Worksheet Functions | |||
| Return a digit in a string of numbers | Excel Discussion (Misc queries) | |||
| Show = sign | Excel Discussion (Misc queries) | |||
| Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
| 16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
Linear Mode
