custom number formating in excel cells

[maximep]

Hi Everybody,

Does anybody know if it's possible and what is the synthax for in the automatic format cells menu to :
- force excell to align the sign - to the right close the number before ( -9.5 instead of having (- 9.5)
- Automatically put a + before positive numbers (+9.5 instead of 9.5)

Thanks a lot for your help

 

[pgc01]

Hi
Welcome to the board

The help on custom number format seems clear to me. Did you read it?

For the case you ask, I guess you can try:

+0;-0;0