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 won't display numbers properly

  • 03-10-2006 9:37am
    #1
    Zascar
    Moderators, Motoring & Transport Moderators, Music Moderators Posts: 12,781 Mod ✭✭✭✭


    Really simple problem I cannot figure out here...

    I have an excel sheet with names and phone numbers etc. When I input phone numbers, sometimes it removes the Zero at the start so I end up with 87xxxxxxx instead of 087xxxxx

    Anyone know how to fix this please?
    Thanks


Comments

  • #2
    petes
    Registered Users, Registered Users 2 Posts: 8,382 ✭✭✭petes


    Zascar wrote:
    Really simple problem I cannot figure out here...

    I have an excel sheet with names and phone numbers etc. When I input phone numbers, sometimes it removes the Zero at the start so I end up with 87xxxxxxx instead of 087xxxxx

    Anyone know how to fix this please?
    Thanks


    Use ' at the start of the number.


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


    A better solution would be to format the cells as text. Right-click on cell or series of cells, select format and then text.


  • #4
    Zascar
    Moderators, Motoring & Transport Moderators, Music Moderators Posts: 12,781 Mod ✭✭✭✭Zascar


    thats it, thanks


Advertisement