A lot of ##### in my spreadsheet.


  1. flogit
    Posts : 359
    windows 7 home premium 64bit
       New #1

    A lot of ##### in my spreadsheet.


    I have decided to download my bank account monthly balance sheet,Got it into a spreadsheet okay But the last column with the total balance I get a lot of these ########. With no figures. Example £100.00 I get #######
    How can I solve this please,The other column's with input's show the figures okay,Its just the last column on the right. Any help here please.

    many Thanks.
      My Computer
    Quote Quote

  3. GEWB
    Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       New #2

    Increase the width of the column.

    Regards,
    GEWB
      My Computer
    Quote Quote

  4. Irene
    Posts : 3,009
    Windows 7 Home Premium 64bit
       New #3

    I agree with GEWB.

    Lots of ways to adjust: Change the column width and row height - Excel - Office.com
      My Computer
    Quote Quote

  6. flogit
    Posts : 359
    windows 7 home premium 64bit
    Thread Starter
       New #4

    many thanks all sorted,It was so simple.Must have been a Senior moment!
    Thankyou very much once again.
      My Computer
    Quote Quote

  7. GEWB
    Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       New #5

    flogit said:
    Must have been a Senior moment!
    Tell me about it! They seem to come more often the older I get...

    Regards,
    GEWB
      My Computer
    Quote Quote

 

  Related Discussions
works spreadsheet
in Microsoft Office

Starting a few months ago any spreadsheet I created in Microsoft Works would develop the "hiccups". The spread sheet would create and you could post entries but only between the fluctuations of the "hourglass" icon cycling about every 2 seconds. I would resolve this by restoring to an earlier...
Spreadsheet
in Microsoft Office

Hello.Just installed Open Office,Now trying to use the spreadsheet system. I thought that I would make an address book up of family names etc,Now when it comes to entering their telephone ie:01683***** when its in the column the nought aint there can anyone explain to me why this is and is there a...
What is the formula that will calculate the percentage of random cells?
I get a monthly listing in my email that comes as a spreadsheet. When I try to open it, I get the message that I do not have Windows Office 2010 installed and it gives me options to purchase,etc. I have another spreadsheet installed on my computer and would prefer to use it but I don't know how to...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 21:58.
Find Us