Thread: negative $'s will not show as red, even though I selected it. I ha
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default negative $'s will not show as red, even though I selected it. I ha
If the cells were formatted as TEXT prior to your formatting them for numbers
you red negative format will not show.

Additionally, if the number was entered as text, indicated by an apostrophe
preceeding the entry your assigned number format does not show.

--
Kevin Backmann


"ask questions" wrote:


--
ask question2
Reply With QuoteReply With Quote