Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

excel query

  • 25-04-2006 9:43am
    #1
    justsomebloke
    Registered Users, Registered Users 2 Posts: 10,407 ✭✭✭✭


    have a problem with the defualt excel settings. Basically when a data value is entered into a cell it seems to divide the number by 100. SO if you enter 386 it will appear as 3.86. It is only the setting for one user that have changed as if i log on as a different user on the same machine the deafult book settings are correct. Anyone have any suggestions

    edit. it will boot up in excel safe mode fine. however there are no add-ins selected to be causing the problem


Comments

  • #2
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 93,596 Mod ✭✭✭✭Capt'n Midnight


    Have you reset the field format to general for that cell in case it was on percentage or something like that.

    Look in the XLstart folder in case there is a template there and turn off macros too


  • #3
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    Right-click on the cell and see what format it is.

    As the Capt'n said, it may be set to something other than general.


Advertisement