Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    meryl.clark
    Guest

    Numbers showing as text (Excel 97 with Win 98)

    I have just started a new job, and have created a few spreadsheets. I have formatted cells as currency (whole columns!) - if I type in 20 it will show as

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Numbers showing as text (Excel 97 with Win 98)

    Attach a censored example.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    meryl.clark
    Guest

    Re: Numbers showing as text (Excel 97 with Win 98)

    Will do tomorrow when back at work! Many thanks for your response. Meryl.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Numbers showing as text (Excel 97 with Win 98)

    You might check your decimal symbol (Control Panel, Regional Settings, Currency) as it may be set to a comma "," or some other character. Worth checking.

    Andrew C

  5. #5
    meryl.clark
    Guest

    Re: Numbers showing as text (Excel 97 with Win 98)

    More information on problem:-
    Problem won't transfer - if you put the spreadsheets on a different PC, problem goes away!
    If you check the format of numbers showing as text, it still shows as Currency,

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbers showing as text (Excel 97 with Win 98)

    I support the idea of Andrew, that the origin of your problem lies in the regional settings. Check the regional settings decimal separator from the Windows control panel. This might explain that it also occurs in Excel and Access and not in another computer (where the regional settings are different).

  7. #7
    meryl.clark
    Guest

    Re: Numbers showing as text (Excel 97 with Win 98)

    Regional settings are all correct. We re-imaged the PC, so these settings are standard across the PC's (but we checked them anyway!).

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Numbers showing as text (Excel 97 with Win 98)

    Just wondering if you still have the problem. If so what happens if you enter =20.19 or +20.19 ?. Do they format correctly ?

    Andrew C

  9. #9
    meryl.clark
    Guest

    Re: Numbers showing as text (Excel 97 with Win 98)

    Still have the problem! If you type any number and include the decimal point, plus any numbers after, it looks like text - no currency symbol, and on the left of the cell. If you then look at the format of the cell, it still shows as currency, with 2 decimal places! If you type a whole number, such as 20, it shows in the correct format -

  10. #10
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: Numbers showing as text (Excel 97 with Win 98)

    Hi
    Just a crazy from the antipodes ..
    What happens if you change keyboards ?
    Clutching at straws !! maybe but I guess you are excited by now.

    Geof

  11. #11
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbers showing as text (Excel 97 with Win 98)

    Just wondering if there might be a kind of conflict between the settings for "Number" and "Currency" in the regional settings, where you can define (in both "number" and "currency") the decimal seperator. Maybe you checked that already, if so, just forget this suggestion.

  12. #12
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Numbers showing as text (Excel 97 with Win 98)

    Hi,
    Just to try and narrow the problem down a bit, do you get text if you type in 20. (i.e. 20 and a decimal point with nothing after it) and then press enter? If so, it's pretty much got to be something to do with your regional settings I would guess.
    Regards,
    Rory

    Microsoft MVP - Excel

  13. #13
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Levin, Manawatu-Wanganui, New Zealand
    Posts
    324
    Thanks
    9
    Thanked 28 Times in 26 Posts

    Re: Numbers showing as text (Excel 97 with Win 98)

    Hi Meryl
    Has anyone been messing around customizing formatting styles and subsequently merged them into the default template ?


    Geof

  14. #14
    meryl.clark
    Guest

    Re: Numbers showing as text (Excel 97 with Win 98)

    Tried changing keyboards. Not intentionally but we had to move to another desk! No different! Grrrrrrr

  15. #15
    meryl.clark
    Guest

    Re: Numbers showing as text (Excel 97 with Win 98)

    If you enter a round number, be it with a decimal point or not, it formats correctly as currency. However you type in a number to 2 decimal places, even if you put in the

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •