 |
|
You are not logged in! F.A.Q Log in Register |
 |
|
 |
 Now online (2)recycle Roger Wilco ...and 445 guests Last 5 registered Oplandisks nothingstar N_loop yipe foxtrotromeo Browse members... |
 |
Members 8025Messages 2614206 Today 10 Topics 127548 |
|
|||||||||
| |||||||||
|
|
OK, I've searched for a solution to this but I'm either using the wrong search terms or I'm a retard. Probably both. Every time I put a number into an excel cell it divides it by 100 eg: Put in 43 and the cell displays 0.43 This is on all spreadsheets, new and old. I can't fathom it out either. I'm still searching the microsoft site. If anyone can suggest what the problem could be, beyond my retardedness I'd be most grateful. Thanks, giginger |
||||||||
| Attached picture | |||||||||
|
|||||||||
|
|
|||||||||
| |||||||||
|
|
sounds like your default template is fucked. can you run a repair from the office CD (put it in, run repair)? |
||||||||
|
|
|||||||||
| |||||||||
|
|
Sounds like a plan to me. I'll give it a whirl. Thank you. |
||||||||
|
|
|||||||||
| |||||||||
|
|
well the easiest would be to set the cells setting to default :) |
||||||||
|
|
|||||||||
| |||||||||
|
|
looks like i should refresh more often :) |
||||||||
|
|
|||||||||
| |||||||||
|
|
try Format, Cells then Number, and set the cell to 'text' |
||||||||
|
|
|||||||||
| |||||||||
|
|
Tolstoyed and Bob: I've already tried that. First things I did. |
||||||||
|
|
|||||||||
| |||||||||
|
|
goto 'Tools - Options - Edit' and uncheck 'Fixed decimals' |
||||||||
|
|
|||||||||
| |||||||||
|
|
Yes, it sounds like your numbers are set to automatically decimalise. |
||||||||
|
|
|||||||||
| |||||||||
|
|
That did it :D! Cheers Phob. Where the hell that got ticked is beyond me.. |
||||||||
|
|
|||||||||
|
Messageboard index
|
|||||||||
