+ Reply to Thread
Results 1 to 11 of 11

Cells with numbers appear blank in formulas

Hybrid View

  1. #1
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,863

    Re: Cells with numbers appear blank in formulas

    If I open it in my computer, and change cell formatting from right adjusted to General I can see only numbers without decimal places remain right formatted (are real numbers). Numbers with decimal separator are recognized as text (are left adjusted).
    May be after
    data tab and import from text, and choose delimited, and then choose by comma.
    don't push "Finish" (Or OK or whatever it is in your version) button but "Next" and on the next page of import from text creator select Advanced and make sure proper decimal and thousand separators are used.

    May be there is a difference between local settings in configuration of present and previous computers. As here, in Poland, decimal separator is coma (not dot) for me it worked just fine Ctrl+H and replace all . into ,).
    But ... try playing with the Advanced and decimal/thousands separator.
    Attached Files Attached Files
    Best Regards,

    Kaper

  2. #2
    Registered User
    Join Date
    02-26-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2013
    Posts
    5

    Re: Cells with numbers appear blank in formulas

    Thank you so much Kaper! The advanced settings before clicking finish worked! You have saved me a lot of trouble! Thank you so so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Blank Cells with formulas
    By Redfeather in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-07-2013, 01:42 PM
  2. Mysterious Blank Cells that my Formulas Are Not Seeing as Blank; Help Required
    By Aimeeeshaw in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-10-2013, 04:34 PM
  3. How can I make a macro ignore blank cells? - Blank Cells have formulas
    By mz1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2013, 08:54 AM
  4. Blank Cells with formulas
    By ozzie4x4 in forum Excel General
    Replies: 2
    Last Post: 06-10-2010, 10:20 AM
  5. blank cells with formulas
    By MAGinRI in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2010, 06:28 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1