How can I get Excel to stop showing p3 numbers as datesPrev TopicNext Topic

• synchronicity

  

  cleveland, tn
  United States
  Member #2,443
  October 4, 2003
  7 Posts
  Offline
  Mar 24, 2010, 3:45 pm

  ▲▼

  When I try to paste the p3 results into excel it displays them as dates.I've tried going under number formatting and changing it to general,but it doesn't work. Please help.
• Toney725

  

  25

  Stone Mountain, GA
  United States
  Member #3,189
  January 1, 2004
  38,279 Posts
  Offline
  Mar 24, 2010, 8:05 pm

  ▲▼

  Try changing it to text.
• libra

  

  25

  Cleveland , Ohio
  United States
  Member #961
  December 27, 2002
  46,589 Posts
  Offline
  Mar 24, 2010, 8:13 pm

  ▲▼

  Highlight the column or columns that the pick - 3 digits are in. Then go to Format , then to cell. click on it. Go to "numbers" , then go to "decimal places" and bring it down to 0. then click on ok. That should take care of the problem. If you have pick - 3's that start with 0 and they are not showing , Highlight the columns again, go to format and to cells, then scroll down to "Custom" in the Type area you will see 0's . If you are using one column for you pick - 3s ,put 3 -0's in this area and hit OK.

  Good Luck Libra Dave