how to put signed integers in cell

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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
 
example ranges: Range("A1") or SELECTION or Range("MyRange")

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum work hours to hours & nearest 10th of an hour 14
Substituting CRLF with "+" - Transforming a cell containing numbersin a sum of its numbers 2
display $ sign in excel sheet 2
number format 3
Zero fill, no decimal, need postive/negative sign 4
Display plus sign for positive numbers 2
Two-tone color column chart 2
Read contents of #Name cell 3

Back
Top