Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
show plus sign in grid
I want to enter a column of numbers, some positive and some negative numbers,
I want the positive number appear with the "+" sign. For Instance $1.94 +0.25 -0.56 I can make the "-" show, but I don't know how to make the "+" show. Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
show plus sign in grid
you can enter ' before the + to make it show:
'+0.25 "Viviank" wrote: I want to enter a column of numbers, some positive and some negative numbers, I want the positive number appear with the "+" sign. For Instance $1.94 +0.25 -0.56 I can make the "-" show, but I don't know how to make the "+" show. Thanks, |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
show plus sign in grid
But then it won't do the calculations. I want them to add up at the bottom.
Sorry, I should have mentioned that. Viv "Sean Timmons" wrote: you can enter ' before the + to make it show: '+0.25 "Viviank" wrote: I want to enter a column of numbers, some positive and some negative numbers, I want the positive number appear with the "+" sign. For Instance $1.94 +0.25 -0.56 I can make the "-" show, but I don't know how to make the "+" show. Thanks, |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
show plus sign in grid
Just use a custom format (click formatcellsnumber and select custom) for
all the cells like +0.00;-0.00;0.00 or if you are using US currency +$#,##0.00;-$#,##0.00;$#,##0.00 no need to physically put it in the cell, just enter the numbers normally and it will display the way you want -- Regards, Peo Sjoblom "Viviank" wrote in message ... But then it won't do the calculations. I want them to add up at the bottom. Sorry, I should have mentioned that. Viv "Sean Timmons" wrote: you can enter ' before the + to make it show: '+0.25 "Viviank" wrote: I want to enter a column of numbers, some positive and some negative numbers, I want the positive number appear with the "+" sign. For Instance $1.94 +0.25 -0.56 I can make the "-" show, but I don't know how to make the "+" show. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell grid lines won't show up, and have box checked | Excel Discussion (Misc queries) | |||
Show grid lines when printing? | New Users to Excel | |||
Why do some grid lines not show in print preview? | Excel Discussion (Misc queries) | |||
Show a grid pattern not corresponding to the cell sizes | Excel Discussion (Misc queries) | |||
Show = sign | Excel Discussion (Misc queries) |