Thread: How do you make a plus sign appear in front of a number?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
kassie kassie is offline
external usenet poster
  
Posts: 515
Default How do you make a plus sign appear in front of a number?
Select yoiur range, click on Format Cells. Select Custom, and type the
following: +#,##0;-#,##0
--
Hth

Kassie Kasselman


"fairchildbrad" wrote:

How do you make a "+" sign appear in front of positive numbers that you have
typed in?
Reply With QuoteReply With Quote