Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells are automatically dividing each # I put in by 10!!!
Hi,
for some reason, every time I put a number in any cell, it is automatically didvide by 10!??? EG, type in 5, get 0.5 Put in 50, get 5!!! Weird and very annoying!!!!!! Everything else seems to be working fine. Can put numbers in fine i formulas, so am guessing it isn`t the keyboard, but not certain. Anyone had the same problem or better still SOLUTION? Thanks guys. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells are automatically dividing each # I put in by 10!!!
Hi,
check the cell format to be sure that has not an special format, go to the cell, right click on the mouse, cell format, number if this helps please click yes "Romileyrunner1" wrote: Hi, for some reason, every time I put a number in any cell, it is automatically didvide by 10!??? EG, type in 5, get 0.5 Put in 50, get 5!!! Weird and very annoying!!!!!! Everything else seems to be working fine. Can put numbers in fine i formulas, so am guessing it isn`t the keyboard, but not certain. Anyone had the same problem or better still SOLUTION? Thanks guys. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells are automatically dividing each # I put in by 10!!!
Check this setting....
In Excel 2007: Office buttonAdvancedEditing OptionsAutomatically insert a decimal point Other versions of Excel: ToolsOptionsEdit tabFixed decimal places -- Biff Microsoft Excel MVP "Romileyrunner1" wrote in message ... Hi, for some reason, every time I put a number in any cell, it is automatically didvide by 10!??? EG, type in 5, get 0.5 Put in 50, get 5!!! Weird and very annoying!!!!!! Everything else seems to be working fine. Can put numbers in fine i formulas, so am guessing it isn`t the keyboard, but not certain. Anyone had the same problem or better still SOLUTION? Thanks guys. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells are automatically dividing each # I put in by 10!!!
Ooops!
In Excel 2007: Office buttonAdvancedEditing OptionsAutomatically insert a decimal point Should be: Office buttonExcel OptionsAdvancedEditing OptionsAutomatically insert a decimal point -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Check this setting.... In Excel 2007: Office buttonAdvancedEditing OptionsAutomatically insert a decimal point Other versions of Excel: ToolsOptionsEdit tabFixed decimal places -- Biff Microsoft Excel MVP "Romileyrunner1" wrote in message ... Hi, for some reason, every time I put a number in any cell, it is automatically didvide by 10!??? EG, type in 5, get 0.5 Put in 50, get 5!!! Weird and very annoying!!!!!! Everything else seems to be working fine. Can put numbers in fine i formulas, so am guessing it isn`t the keyboard, but not certain. Anyone had the same problem or better still SOLUTION? Thanks guys. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells are automatically dividing each # I put in by 10!!!
WHOO HOOO! That was it T. VALKO!
Don`t know how I did it in the first place, but you were bang on mate; I had an automatic seting of 1 DP switched on. What a relief. I thought my keyboard had a ghost! Thanks a million. Keep up the good work. "T. Valko" wrote: Check this setting.... In Excel 2007: Office buttonAdvancedEditing OptionsAutomatically insert a decimal point Other versions of Excel: ToolsOptionsEdit tabFixed decimal places -- Biff Microsoft Excel MVP "Romileyrunner1" wrote in message ... Hi, for some reason, every time I put a number in any cell, it is automatically didvide by 10!??? EG, type in 5, get 0.5 Put in 50, get 5!!! Weird and very annoying!!!!!! Everything else seems to be working fine. Can put numbers in fine i formulas, so am guessing it isn`t the keyboard, but not certain. Anyone had the same problem or better still SOLUTION? Thanks guys. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cells are automatically dividing each # I put in by 10!!!
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Romileyrunner1" wrote in message ... WHOO HOOO! That was it T. VALKO! Don`t know how I did it in the first place, but you were bang on mate; I had an automatic seting of 1 DP switched on. What a relief. I thought my keyboard had a ghost! Thanks a million. Keep up the good work. "T. Valko" wrote: Check this setting.... In Excel 2007: Office buttonAdvancedEditing OptionsAutomatically insert a decimal point Other versions of Excel: ToolsOptionsEdit tabFixed decimal places -- Biff Microsoft Excel MVP "Romileyrunner1" wrote in message ... Hi, for some reason, every time I put a number in any cell, it is automatically didvide by 10!??? EG, type in 5, get 0.5 Put in 50, get 5!!! Weird and very annoying!!!!!! Everything else seems to be working fine. Can put numbers in fine i formulas, so am guessing it isn`t the keyboard, but not certain. Anyone had the same problem or better still SOLUTION? Thanks guys. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dividing cells | Excel Discussion (Misc queries) | |||
Excel automatically dividing value by 100... | Excel Discussion (Misc queries) | |||
Need help w/ adding cells and dividing SUM by number of cells | Excel Worksheet Functions | |||
Dividing range of numbers automatically | Excel Worksheet Functions | |||
Dividing up cells | Excel Discussion (Misc queries) |