Exports come across as text.
Graybuck
Member Posts: 6
From Reports>Transactions>Export>.csv all my values are exported as text, not numbers. I must be doing something wrong. Help!
in Using Wave
0
Comments
@Graybuck,
Have not seen that. You can always use @value(cell ref) to convert numbers that are text to numbers. For example
1 '236 @value(A1) result will be 236
2 '325 @value(A2) result will be 325
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?)
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