| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change display of positive numbers
Hello,
Is it possible to change the display of positive numbers so that it displays the plus sign (+) in MS Office Excel 2003? I tried the help screens but couldn't find anything. Many thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change display of positive numbers
Hello.
Try custom format : +#0;-#;0 You'll have to change it if you want to display decimals, thousands symbols, etc. HTH Daniel Hello, Is it possible to change the display of positive numbers so that it displays the plus sign (+) in MS Office Excel 2003? I tried the help screens but couldn't find anything. Many thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change display of positive numbers
That's done the trick! Many thanks.
"Daniel.C" wrote: Hello. Try custom format : +#0;-#;0 You'll have to change it if you want to display decimals, thousands symbols, etc. HTH Daniel Hello, Is it possible to change the display of positive numbers so that it displays the plus sign (+) in MS Office Excel 2003? I tried the help screens but couldn't find anything. Many thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| how do i display a variance in all positive numbers? | Excel Worksheet Functions | |||
| How do I display positive numbers on either side of the x-axis? | Charts and Charting in Excel | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
Linear Mode
