Cell formatting

  • Thread starter Thread starter srug51
  • Start date Start date
S

srug51

Hi
I wonder if some one can help me.

I have imported into Windows XP Profesional old spreadsheets fro
Windows 98. The problem I am having is I am unable to format cell
without decimals.
Excel is changing numbers that I had without decimals in to decimals
For example if I had 17 and I change that number to 18 it will show i
as 0.18. I have tried formatting the cells from the format tool bu
without any luck as even here it is showing me the general numbers wit
2 decimal points!

Could it be something that was done when Windows XP was first loaded?

Any help will be appreciate
 
Check under tools, options, edit, and see if fixed decimal is checked
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 

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

Back
Top