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
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
"=?Utf-8?B?a2luZ3M=?=" <[email protected]>
wrote in
news:[email protected]:
> 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
Tools > Options > Edit tab.
Uncheck fixed decimals box.
Mangesh
"kings" <[email protected]> wrote in message
news:[email protected]...
> 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
HiOriginally Posted by kings
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
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks