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 all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.

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

justsomebloke · 2006-04-25 09:43:53

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…

25-04-2006 10:43am

#1

justsomebloke

Registered Users, Registered Users 2 Posts: 10,407 ✭✭✭✭

Join Date: June 2002

Posts: 9658

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

0

Comments

#2 26-04-2006 1:17pm

Capt'n Midnight

Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 92,385 Mod ✭✭✭✭

Join Date: March 2003

Posts: 90623

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

0
#3 26-04-2006 7:39pm

Tom Dunne

Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭

Join Date: May 2001

Posts: 21052

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.

0