Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
appearance of numbers
hi,
ive been working on an assignment for school ive completed most of it but ive run into a problem. if i try to type in a number into a cell, for example if i type 10 and hit enter, 0.01 shows up in the cell instead of 10. i kno its not a decimal place setting issue because when i change it, it doesnt fix anything. if anyone could tell me what setting i have on thats altering the numbers in such a way that would be greatly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
appearance of numbers
Tools Options Edit tab uncheck Fixed decimal Places
"mvella" wrote: hi, ive been working on an assignment for school ive completed most of it but ive run into a problem. if i try to type in a number into a cell, for example if i type 10 and hit enter, 0.01 shows up in the cell instead of 10. i kno its not a decimal place setting issue because when i change it, it doesnt fix anything. if anyone could tell me what setting i have on thats altering the numbers in such a way that would be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
appearance of a concatenated value | Excel Worksheet Functions | |||
Excel Appearance | Excel Discussion (Misc queries) | |||
Cell appearance | Excel Discussion (Misc queries) | |||
Vlookup second appearance | Excel Discussion (Misc queries) | |||
Spreadsheet appearance | Excel Discussion (Misc queries) |