Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel devides every number by 100
Even when I open a brand new file. I input a number (ie 5) and get 0.05 back.
I have tried doing everything in cell format etc.. anyone have an idea? it is very annoying and adding loads of work to my project. thanks |
#2
|
|||
|
|||
"?B?a2luZ3M=?="
wrote in : Even when I open a brand new file. I input a number (ie 5) and get 0.05 back. I have tried doing everything in cell format etc.. anyone have an idea? it is very annoying and adding loads of work to my project. thanks G'day, In Tools\Options\Edit turn off Fixed decimal If that doesn't help, I don't know. Cheers, Julian -- Julian Mattay, email: julian x mattay z csiro x au (where x - dot, z - at) Local IT Bloke CSIRO, Forestry and Forest Products Ph: +61 8 8721 8118 Mt Gambier, South Australia, Australia Fax: +61 8 8723 9058 |
#3
|
|||
|
|||
Tools Options Edit tab.
Uncheck fixed decimals box. Mangesh "kings" wrote in message ... Even when I open a brand new file. I input a number (ie 5) and get 0.05 back. I have tried doing everything in cell format etc.. anyone have an idea? it is very annoying and adding loads of work to my project. thanks |
#4
|
|||
|
|||
kings Wrote: Even when I open a brand new file. I input a number (ie 5) and get 0.05 back. I have tried doing everything in cell format etc.. anyone have an idea? it is very annoying and adding loads of work to my project. thanks Hi I had just the same problem about two years ago, and all changes in Eccel options did not help. I thought had an excel macro virus. etc.! The problem has then been resolved, but I have to remeber how Sorry that does not help, hopefully me or somebody else could write you back shortly -- Accountant ------------------------------------------------------------------------ Accountant's Profile: http://www.excelforum.com/member.php...o&userid=22662 View this thread: http://www.excelforum.com/showthread...hreadid=376238 |
#5
|
|||
|
|||
Thanks you all fro your help. the fixed decimal thing woprked.
Cheers Stephen "Accountant" wrote: kings Wrote: Even when I open a brand new file. I input a number (ie 5) and get 0.05 back. I have tried doing everything in cell format etc.. anyone have an idea? it is very annoying and adding loads of work to my project. thanks Hi I had just the same problem about two years ago, and all changes in Eccel options did not help. I thought had an excel macro virus. etc.! The problem has then been resolved, but I have to remeber how Sorry that does not help, hopefully me or somebody else could write you back shortly -- Accountant ------------------------------------------------------------------------ Accountant's Profile: http://www.excelforum.com/member.php...o&userid=22662 View this thread: http://www.excelforum.com/showthread...hreadid=376238 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
Excel random number | Excel Discussion (Misc queries) | |||
Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
How do I start an Excel entry with then number 0? | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) |