Exports come across as text.

GraybuckGraybuck Member Posts: 6

From Reports>Transactions>Export>.csv all my values are exported as text, not numbers. I must be doing something wrong. Help!


  • MikegMikeg Member Posts: 874 ✭✭✭

    Have not seen that. You can always use @value(cell ref) to convert numbers that are text to numbers. For example

    A                 B

    1 '236 @value(A1) result will be 236
    2 '325 @value(A2) result will be 325

  • GraybuckGraybuck Member Posts: 6

    Thanks Mike. I've used the value function as a workaround, but it's a hassle for bigger exports. However I must be doing something wrong in the export process. (what good is an accounting worksheet in text?)

  • MikegMikeg Member Posts: 874 ✭✭✭

    Not sure that you would doing anything incorrect on the export. You may want to research excel options, maybe there is something in there that is causing your data to be converted to text. Best of luck

Sign In or Register to comment.