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

How do I tell Excell 2007 not to decide how it is going to format cell contents

  • 12-08-2010 4:00pm
    #1
    FSL
    Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭


    I have an Excel document which contains data from another system. One column is a reference many of which are in the form nnnnn-nnnnn. If the first part of the reference is between 1 and 12 and the second part is between 1 and 31 Excel insists on showing it as a date. i.e. 1-18 displays as January 18 but 13-18 or 1-32 would display as typed. No matter how I format the cells Excell just ignores it.

    I also had a similar problem where I extracted some information from a series of files. One of the items was the scale used, in the form 1:nnnnn which only displayed correctly if nnnn was greater than 9999. As I was generating the data I got around it by putting a space as the first character, Excel then displayed the data correctly.

    I have no control over the reference data as that is generated by from proprietary software over which I have no control.


Comments

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


    format the cells as text


  • #3
    homer911
    Registered Users, Registered Users 2 Posts: 5,150 ✭✭✭homer911


    Something sounds strange - is your source file really Excel or is it a CSV file?

    If the file is CSV, then you have some hope of controlling how Excel handles it by editing it in a text editor before opening in Excel

    If the data really is in Excel, then using a text format on a value that is already displayed as a date, will only display it as a number in text format. Its only if the cell is formatted as text before the value is entered that it will be displayed as desired


  • #4
    FSL
    Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭FSL


    It is in Excel output from a Microsoft accounting package. I already knew it would display correctly if the cell was pre formatted. I cannot however pre format a spreadsheet generated by another system.

    As it happens the result set is displayed before being exported so yes I can select all, copy, open a spread sheet, format the appropriate column(s) and paste the data. However your average used does not want to do that when there is an export button.


Advertisement