Column Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Exell 2003, when i enter a number it appears as a 2 decimal place
fraction, rather than a full number.
The work sheet was created, originally in Office 97
 
Are you saying that the number is correct, just rounded to two decimal
places? If so, reformat the cell(s) as General.

If you mean say 100 is showing as .01, this sounds like Fixed Decimal. Go to
menu Tools>Options>Edit and uncheck the Fixed Decimal box.
 
You must log in or register to reply here.

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

Problem entering numbers 3
Trim varying decimals from column of numbers 9
Decimal point in general format 1
need some columns to auto add decimal pt & others to not - How to. 2
Access stripping decimal places in query 1
Setting formatting for 2 places 3
Adding up total hours worked on employee schedule using various criteria 0
Change number from multiple decimals to 2 3

Back
Top