| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
+ prefix on positive numbers
Hi,
I know excel displays negative numbers prefixed with a - sign, is it possible to easily have excel put a + sign before positive numbers automatically? Any help greatly appreciated, Cheers, Aaron. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
+ prefix on positive numbers
Slashman wrote:
Hi, I know excel displays negative numbers prefixed with a - sign, is it possible to easily have excel put a + sign before positive numbers automatically? Any help greatly appreciated, Cheers, Aaron. Hi Aaron, you can build a custom format. From menu Format, Cells select Number tab, then choose Custom under Categories and type: +#.##0;-#.##0 under Type. -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
+ prefix on positive numbers
Hi Frank,
Thanks for that it works great. Cheers, Aaron. Franz Verga wrote: Slashman wrote: Hi, I know excel displays negative numbers prefixed with a - sign, is it possible to easily have excel put a + sign before positive numbers automatically? Any help greatly appreciated, Cheers, Aaron. Hi Aaron, you can build a custom format. From menu Format, Cells select Number tab, then choose Custom under Categories and type: +#.##0;-#.##0 under Type. -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
+ prefix on positive numbers
I just noticed that, it gets rid of the 0 before a fractional number.
So +1.3 is fine but 0.3 becomes +.3. Is there a way of having it not remove the first 0? Cheers, Aaron. Slashman wrote: Hi Frank, Thanks for that it works great. Cheers, Aaron. Franz Verga wrote: Slashman wrote: Hi, I know excel displays negative numbers prefixed with a - sign, is it possible to easily have excel put a + sign before positive numbers automatically? Any help greatly appreciated, Cheers, Aaron. Hi Aaron, you can build a custom format. From menu Format, Cells select Number tab, then choose Custom under Categories and type: +#.##0;-#.##0 under Type. -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
+ prefix on positive numbers
Slashman wrote:
I just noticed that, it gets rid of the 0 before a fractional number. So +1.3 is fine but 0.3 becomes +.3. Is there a way of having it not remove the first 0? Yes, use: +#.##0.#;-#.##0.# or better +#.##0.0;-#.##0.0 Slashman wrote: Hi Frank, Thanks for that it works great. Cheers, Aaron. Franz Verga wrote: Slashman wrote: Hi, I know excel displays negative numbers prefixed with a - sign, is it possible to easily have excel put a + sign before positive numbers automatically? Any help greatly appreciated, Cheers, Aaron. Hi Aaron, you can build a custom format. From menu Format, Cells select Number tab, then choose Custom under Categories and type: +#.##0;-#.##0 under Type. -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
+ prefix on positive numbers
I wonder if the period of the end of sentence made you change the formatting to
include multiple decimal points. I would have guessed something like: +0.000;-0.000 would be ok. Franz Verga wrote: Slashman wrote: I just noticed that, it gets rid of the 0 before a fractional number. So +1.3 is fine but 0.3 becomes +.3. Is there a way of having it not remove the first 0? Yes, use: +#.##0.#;-#.##0.# or better +#.##0.0;-#.##0.0 Slashman wrote: Hi Frank, Thanks for that it works great. Cheers, Aaron. Franz Verga wrote: Slashman wrote: Hi, I know excel displays negative numbers prefixed with a - sign, is it possible to easily have excel put a + sign before positive numbers automatically? Any help greatly appreciated, Cheers, Aaron. Hi Aaron, you can build a custom format. From menu Format, Cells select Number tab, then choose Custom under Categories and type: +#.##0;-#.##0 under Type. -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
+ prefix on positive numbers
Slashman Wrote: Hi, I know excel displays negative numbers prefixed with a - sign, is it possible to easily have excel put a + sign before positive numbers automatically? Any help greatly appreciated, Cheers, Aaron.Hi Slashman, To add to the other great responces. Puts a plus sign in front of positive amounts, a minus before negatives, and nothing in front of zeroes. something like: +#,##0.0;"-"#,##0.0;#,##0.0 +#,##0.00;"-"#,##0.00;#,##0.00 0.3 becomes +0.3 or as in the second line +0.30 -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=572870 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
+ prefix on positive numbers
Cool,
Thanks heaps everyone, great help. Cheers, Aaron. Desert Piranha wrote: Slashman Wrote: Hi, I know excel displays negative numbers prefixed with a - sign, is it possible to easily have excel put a + sign before positive numbers automatically? Any help greatly appreciated, Cheers, Aaron.Hi Slashman, To add to the other great responces. Puts a plus sign in front of positive amounts, a minus before negatives, and nothing in front of zeroes. something like: +#,##0.0;"-"#,##0.0;#,##0.0 +#,##0.00;"-"#,##0.00;#,##0.00 0.3 becomes +0.3 or as in the second line +0.30 -- Desert Piranha ------------------------------------------------------------------------ Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934 View this thread: http://www.excelforum.com/showthread...hreadid=572870 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| numbers with 0 prefix | Excel Discussion (Misc queries) | |||
| counting a string of negative or positive numbers | Excel Discussion (Misc queries) | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| Compare Negative & Positive Numbers | New Users to Excel | |||
| Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
Linear Mode
