Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimal points in my spreadsheet
I have a spreadsheet that I have been using for over a year. It helps
to keep track of how many people are getting to our website and how. Today I opened the spreadsheet to update the information and when I type in for example 99 over the 98 that is there the total it comes up with is 115.99 from 213, and it changes the 99 to 0.99. I already tried changing the column to number and general and that didn't work. Also, if I open a new exel spreadsheet it does the same thing. So I know the problem is in the setting somewhere but I can't find out where. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
decimal points in my spreadsheet
Try this:
From the Excel main menu: <tools<options<edit tab UNcheck: Fixed decimal places Does that help? *********** Regards, Ron XL2002, WinXP "help" wrote: I have a spreadsheet that I have been using for over a year. It helps to keep track of how many people are getting to our website and how. Today I opened the spreadsheet to update the information and when I type in for example 99 over the 98 that is there the total it comes up with is 115.99 from 213, and it changes the 99 to 0.99. I already tried changing the column to number and general and that didn't work. Also, if I open a new exel spreadsheet it does the same thing. So I know the problem is in the setting somewhere but I can't find out where. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can Excel generate more decimal points ie 5.5% not 5% | Excel Discussion (Misc queries) | |||
hlookup function | Excel Worksheet Functions | |||
Aligning Decimal Points with non-numeric data | Excel Discussion (Misc queries) | |||
why 2003 excell does not accept dot as decimal points | Excel Discussion (Misc queries) | |||
Decimal points not needed | Excel Worksheet Functions |