how to put signed integers in cell

[Andrew]

Hello,
I have a spreadsheet which has values of -10 to +10, and I'd like to
have the positive and negative signs show up. Does anyone know how to
format this?

thanks

 

[Patrick Molloy]

just format the cells menu: Format / Cells

 

[Rick Rothstein]

Use this Custom Format on the cells...

+0;-0;0

 

[Andy]

just format the cells  menu: Format / Cells

None of the formats show a signed integer. There is a negative sign
available, but not a positive sign.

 

[Patrick Molloy]

example ranges: Range("A1") or SELECTION or Range("MyRange")

Range("A:A").NumberFormat = "+0;-0;0"