Excel has the NUM lock key on - my charts are messed up

B

bethe

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do I turn off the NUM lock key so that Excel will recognize date and other fields as text and not numbers. Thanks.
 
C

Carl Witthoft

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

How do I turn off the NUM lock key so that Excel will recognize date and
other fields as text and not numbers. Thanks.
Click to expand...

It has nothing to do with NUMLOCK.

Select the cells of interest and grab the Menu Format/Cells and
navigate the number formatting until you see the list of options, and
select TextOnly.

The menus vary a lot from one version of Office to another, so I dunno
what it looks like in 2008, sorry
 

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

Num Lock Stuck 2
Scroll Lock 1
page fields on pivot charts 0
2008 charts are resized in 2007 4
Excel Charts 0
How to stop Excel from rounding up 2
XIRR XNPV 1
Page down key locked on excel worksheet 1

Top