Office:Mac Excel

G

Guest

when entering a number in a cell, say 5, it appears as 0.05?
The number seems to dived by 100 for some reason.
I have tried formating cells, worksheets etc.. but cannot solve this problem?

can anyone help solve this weird problem?
 
G

Guest

If it is Office/Excel 2004 for Mac it would be under

excel>preferences>edit

Regards,

Peo Sjoblom
 
G

Guest

Thank you for your help!

I have been using excel in mac for 18 months and this problem came about
only recently.

I do not know how the preferences got changed?

Have a Happy Christmas and New Year!!!!!
 

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

Excel VBA 1
formating problem 5
Excel 2010 not allowing me to paste as formula 5
Data Entry Problem 3
Numeric Data Entry problem 2
Cell format dialog box will not open 1
number formatting 2
compare for high with two or more cells and then flag. 1

Top