Thread: How to add PivotTable drop down selector to another tab?
View Single Post
  #40 (permalink)  
Old 02-24-2008, 06:51 AM
Troy2287 Troy2287 is offline
Banned
  
Join Date: Feb 2008
Location: New South Wales, Australia
Posts: 23
iTrader: (0)
Troy2287 is on a distinguished road
Send a message via MSN to Troy2287
Default
Ok simple to fix.
1.Right-click the desired cell.
2.Select "Format Cells...".
3.On the "Number" tab set the category as "Text".
Reply With Quote