cell display

J

Jim_Paisley

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Why are pound signs coming up in cells with formulas?
 
P

pjonesCET

Column width not large enough

Click on the main column header (A,B.C, etc) so entire column is selected. Go to Format menu and column then click autofit.
 
J

John_McGhie_[MVP]

Or your currency setting is wrong :)

When working with Excel, it's a good idea to call this # a hash sign, so you
do not confuse people who think you mean one of these £

Cheers

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Why are
pound signs coming up in cells with formulas?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 

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


Top