| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Showing plus sign on positive numbers - SOLVED
OHMYGOD that's too simple! But damn if it didn't work on every scenario
I never tried that +#.00;-#.00;0 I thought the # signs had to go where I didn't want zeros... ::rolls eyes: You have saved me alot of work - Thank you VERY MUCH ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display plus sign for positive numbers | Excel Discussion (Misc queries) | |||
| showing only positive numbers | Excel Discussion (Misc queries) | |||
| -ve no with -1; positive with sign+ and 0 no sign? Tks. | Excel Worksheet Functions | |||
| hot to get + sign on positive nos | Excel Discussion (Misc queries) | |||
| FORMULA TO ADD POSITIVE AND NEGATIVE NUMBERS, REGARDLESS OF SIGN | Excel Discussion (Misc queries) | |||
![The Redhead[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
