YB
BannerBanner

Any Excel Gurus?

Author
OTTO
Pro-Member
  • Total Posts : 3852
  • Reward points: 10416
  • Joined: 2002/04/27 19:16:58
  • Location: United Kingdom
  • Status: offline
2007/06/08 23:32:00 (permalink)
USA DEALS

Any Excel Gurus?

I have an excel spread sheet, basic and simple but in one of the columns where I want to includ "mobile phone number"

I cant seem to work it so that it accepts the number i give.. excel takes off the first 0 and tried to make a sum out of it, i've tried changing colum to text, number etc but cant get the hang of it.. any way i can input a number that starts with 0 ( Zero)

Thanks
#1

5 Replies Related Threads

    OTTO
    Pro-Member
    • Total Posts : 3852
    • Reward points: 10416
    • Joined: 2002/04/27 19:16:58
    • Location: United Kingdom
    • Status: offline
    RE: Any Excel Gurus? 2007/06/08 23:34:12 (permalink)
    strangely enough if i add the "home phone" i.e 0151 0161 01925 .. excel accepts it.. but when i try and put a mobile number in e.g 07812111111111 excel changes it to 781211111

    any clues?
    #2
    johnnybike
    Olympian Member
    • Total Posts : 575
    • Reward points: 5388
    • Joined: 2007/03/08 22:47:21
    • Location: Leeds
    • Status: offline
    RE: Any Excel Gurus? 2007/06/08 23:38:08 (permalink)
    If you put a single quote (') in front it keeps the format.
    I think there is a better answer though. Will keep on looking

    John
    #3
    Max Power
    Olympian Member
    • Total Posts : 744
    • Reward points: 8204
    • Joined: 2006/05/22 17:36:30
    • Status: offline
    RE: Any Excel Gurus? 2007/06/08 23:46:51 (permalink)
    right click - format cells - change it to text

    #4
    johnnybike
    Olympian Member
    • Total Posts : 575
    • Reward points: 5388
    • Joined: 2007/03/08 22:47:21
    • Location: Leeds
    • Status: offline
    RE: Any Excel Gurus? 2007/06/08 23:47:25 (permalink)
    Here we are

    Highlight the cells/column/row you want this format to apply to, go to FORMAT > CELLS, (or CTRL+1)
    on the number tab scroll down to Custom in th category window, and manually type in 0000000 in the Type window (where the number of characters you want is the number of "0"s you type in - 11 for a mobile no
    #5
    OTTO
    Pro-Member
    • Total Posts : 3852
    • Reward points: 10416
    • Joined: 2002/04/27 19:16:58
    • Location: United Kingdom
    • Status: offline
    RE: Any Excel Gurus? 2007/06/09 01:15:37 (permalink)

    ORIGINAL: johnnybike

    Here we are

    Highlight the cells/column/row you want this format to apply to, go to FORMAT > CELLS, (or CTRL+1)
    on the number tab scroll down to Custom in th category window, and manually type in 0000000 in the Type window (where the number of characters you want is the number of "0"s you type in - 11 for a mobile no


    thanks mate
    #6
    Jump to:
    ©2017 All content is copyright of MuscleTalk.co.uk and its use elsewhere is prohibited.
    (posting guidelines | privacy | advertise | earnings disclaimer | contact us | supported by)
    © 2017 APG vNext Commercial Version 5.5