Hi, When you export from bullet to excel what do you need to do to get excel to recognise numbers. Thanks Suzanne

Vote Up
0
Vote Down

Hi, When you export from bullet to excel what do you need to do to get excel to recognise numbers. Thanks Suzanne

1 answer

Vote Up
0
Vote Down
Peter Connor ⋅ Staff October 10, 2015
Public

Hi S, What exactly do you mean? Pete

#answer-1959
  1. Peter Connor October 10, 2015
    Hi Suzanne. Select the cells you want to change in Excel and select Format from the menu. Select currency and it should do what you want.
  2. suzanne carroll October 10, 2015
    When I export the accounts payable for example to excel, it won't recognise the figures as numbers and I can't change the format. I actually have to type the figures manually. It's fine on some exports but not that one or the P&L.
  3. Peter Connor October 10, 2015
    Hi Suzanne,
    Can you upload the excel file into our chat please and I'll have a look. Pete
  4. suzanne carroll October 10, 2015
    Here you go
  5. Peter Connor October 10, 2015
    I'll have a look now, hang on.
  6. Peter Connor October 10, 2015
    Hmm, this is what I'm seeing.
  7. Peter Connor October 10, 2015
    If I look at what the spreadsheet is doing to the boxes you'll see it's currency. If you want to changes this select the cells and then click currency and pick from the drop down.
  8. suzanne carroll October 10, 2015
    Yes, but if you try to sum the numbers you will get zero as it is not recognising the figures
  9. Peter Connor October 10, 2015
    Ok, let me try that.
  10. Peter Connor October 10, 2015
    Hi Suzanne,
    I see the issue, we'll have a look at that for you. Here is what you can do as a fix. We'll have a look at the export.
    Select all the cells.
    Click the <i> error
    Click "convert to number".
  11. Peter Connor October 10, 2015
    Then you'll be able to do 'sum'.
    Pete
  12. suzanne carroll October 10, 2015
    ok brilliant. Thanks for your help
  13. Peter Connor October 10, 2015
    Cool, not sure why that's happening. We'll have a look at it and make sure we don't waste your time again.

    Thanks for your patients Suzanne :)

    Pete

Please login or Register to Submit Answer