+ Reply to Thread
Results 1 to 4 of 4

Cell Format Not showing correctly but only "####" after switching from 32bit to 64bit

  1. #1
    Registered User
    Join Date
    10-21-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2013
    Posts
    2

    Cell Format Not showing correctly but only "####" after switching from 32bit to 64bit

    Hello Everyone,

    Yesterday i switched from 32bit to 64bit version of excel and after opening all the files i that i usually work on, i see that the cell which was supposed to display the currency unit of 'Bangladeshi Taka ৳' and with the number value is instead showing '####### #####'. I tried to delete the custom format it is supposedly showing but the same error. If anyone can help me in this regard it would be very helpful.

    I'm attaching the excel file and a pdf file (of how it should look).

    Thank in advance for the support.
    Attached Files Attached Files

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Cell Format Not showing correctly but only "####" after switching from 32bit to 64bit

    Select all cell with Accounting format and change it to:

    accounting.jpg

    or tell what format should be in column with "In TK" ?

    If you want Bangladesh:

    bangla.jpg
    Last edited by sandy666; 07-14-2017 at 01:30 AM.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    10-21-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Cell Format Not showing correctly but only "####" after switching from 32bit to 64bit

    thanks sandy666 for the reply..

    i did all those things before i posted here...none worked. any other suggestion? may be you can have a look at the file?

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Cell Format Not showing correctly but only "####" after switching from 32bit to 64bit

    I can't say more because I see normal number
    look at attached file what you see now?

    btw. Ex 64-bit

    Edit: maybe tick-off "use system separtors" in Option - Advanced
    Attached Files Attached Files
    Last edited by sandy666; 07-14-2017 at 01:40 AM.

+ 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. Replies: 7
    Last Post: 11-08-2015, 03:57 PM
  2. Replies: 5
    Last Post: 07-16-2015, 10:14 AM
  3. Convert 32Bit to 64Bit
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-10-2015, 07:42 PM
  4. my 32bit vba code won't run in 64bit
    By ncaravela in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 02:15 PM
  5. Replies: 3
    Last Post: 11-23-2012, 01:57 AM
  6. Replies: 2
    Last Post: 11-01-2012, 04:35 PM
  7. Convert MostRecent Function from 32bit to 64bit (XP>WIN&)
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-28-2012, 04:34 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