We’d like to remind Forumites to please avoid political debate on the Forum.

This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.

📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

MS Excel help please

Nile
Nile Posts: 14,845 Forumite
Part of the Furniture 10,000 Posts Name Dropper Photogenic
in Techie Stuff
I'd like some help please with MS Excel 2007. I'm trying to enter a number in a cell but I'm having problems.

I want to enter the number 001299 for example. It drops the first two digits (zeros) and leaves 1299 in the cell.

Is it possible to display 001299 in the cell? If yes, can you explain how to do it.

Thanks

Nile
10 Dec 2007 - Led Zeppelin - I was there. :j [/COLOR]:cool2: I wear my 50 (gold/red/white) blood donations pin badge with pride. [/SIZE][/COLOR]Give blood, save a life. [/B]
«1

Comments

  • VfM4meplse
    VfM4meplse Posts: 34,269 Forumite
    10,000 Posts Combo Breaker I've been Money Tipped!
    Use an apostrophe beforehand, ie enter: '001299 .

    HTH
    Value-for-money-for-me-puhleeze!

    "No man is worth, crawling on the earth"- adapted from Bob Crewe and Bob Gaudio

    Hope is not a strategy :D...A child is for life, not just 18 years....Don't get me started on the NHS, because you won't win...I love chaz-ing!
  • Figment
    Figment Posts: 2,643 Forumite
    Part of the Furniture Combo Breaker
    Will this number be used in any calculations?

    If not, then you can define the cell as Text, then numbers will display exactly as entered.

    Select cell(s), then Format > Cells > Number Select 'Text' from the list.
    How do I add a signature?
  • Nile
    Nile Posts: 14,845 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    Figment wrote: »
    Will this number be used in any calculations?

    If not, then you can define the cell as Text, then numbers will display exactly as entered.

    Select cell(s), then Format > Cells > Number Select 'Text' from the list.

    Thanks Figment.

    No, it's not being used in a calculation but I did want it to show as a number...........rather than as text.
    10 Dec 2007 - Led Zeppelin - I was there. :j [/COLOR]:cool2: I wear my 50 (gold/red/white) blood donations pin badge with pride. [/SIZE][/COLOR]Give blood, save a life. [/B]
  • Figment
    Figment Posts: 2,643 Forumite
    Part of the Furniture Combo Breaker
    it will look like a number (e.g. 001299) and you can format the dell to align it to left/right/centre. The only difference is the cell contents are defined as text so you won't be able to use them in calculations (which you just said you don't need).
    How do I add a signature?
  • VfM4meplse
    VfM4meplse Posts: 34,269 Forumite
    10,000 Posts Combo Breaker I've been Money Tipped!
    You didn't try my shortcut :(
    Value-for-money-for-me-puhleeze!

    "No man is worth, crawling on the earth"- adapted from Bob Crewe and Bob Gaudio

    Hope is not a strategy :D...A child is for life, not just 18 years....Don't get me started on the NHS, because you won't win...I love chaz-ing!
  • System
    System Posts: 178,365 Community Admin
    10,000 Posts Photogenic Name Dropper
    Format > Cell > Number >custom then enter 6 0s (000000)

    It stays as a number but displays with leading zeroes.
    This is a system account and does not represent a real person. To contact the Forum Team email forumteam@moneysavingexpert.com
  • Nile
    Nile Posts: 14,845 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    VfM4meplse wrote: »
    You didn't try my shortcut :(

    Yes, I've tried it................but it puts a little green flag in the left corner of the cell.
    10 Dec 2007 - Led Zeppelin - I was there. :j [/COLOR]:cool2: I wear my 50 (gold/red/white) blood donations pin badge with pride. [/SIZE][/COLOR]Give blood, save a life. [/B]
  • Nile
    Nile Posts: 14,845 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    !!!!!! wrote: »
    Format > Cell > Number >custom then enter 6 0s (000000)

    It stays as a number but displays with leading zeroes.

    It doesn't when I enter 001299............I end up with 1299 again.
    10 Dec 2007 - Led Zeppelin - I was there. :j [/COLOR]:cool2: I wear my 50 (gold/red/white) blood donations pin badge with pride. [/SIZE][/COLOR]Give blood, save a life. [/B]
  • Nile
    Nile Posts: 14,845 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    It looks like I can't have the number 001249 in the cell unless I enter it as text or I have a little green flag in the corner..............unless someone knows a way.;)
    10 Dec 2007 - Led Zeppelin - I was there. :j [/COLOR]:cool2: I wear my 50 (gold/red/white) blood donations pin badge with pride. [/SIZE][/COLOR]Give blood, save a life. [/B]
  • Tigsteroonie
    Tigsteroonie Posts: 24,954 Forumite
    Part of the Furniture 10,000 Posts Name Dropper Photogenic
    Hmmm ... well, so far I can offer you "00 12 49" (with spaces) by selecting the Custom formats, French (France), Numero de Telephone (Maroc).

    I'll keep hunting through the remaining languages!
    :heartpuls Mrs Marleyboy :heartpuls

    MSE: many of the benefits of a helpful family, without disadvantages like having to compete for the tv remote

    :) Proud Parents to an Aut-some son :)
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 351.7K Banking & Borrowing
  • 253.4K Reduce Debt & Boost Income
  • 454K Spending & Discounts
  • 244.7K Work, Benefits & Business
  • 600.1K Mortgages, Homes & Bills
  • 177.3K Life & Family
  • 258.4K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.
Update Your Picture