one cell that Numbers store as text in output file

Question

Hi, need some help! In this column in output file, all the other cells/data are fine but there is one cell which the excel have a message tell me "Number store as text",  I don't know why this particular cell is store as text while other cells are fine. What could be the reason? Thank you.

gabrielvilella · Answer

Are you updating an existing sheet preserving the formatting? If so, please erase the formatting and try again. Another way to test this would be outputting to a new file and checking if the issue persists. Also, please make sure that you have a numeric field type on that column in Alteryx, such as double.

yc151 · Answer

hi, Dawn

Please see below pics from my output files, the -13M is not sum up when I select those two cells due to "Number store as text" message  indicated by excel. the 13M is the only cell have this issue while others can sum up just fine. I may not be able to upload the workflow cuz I used real company data.  I used table, render tool, etc. Do you know how to solve this? Thank you.

DawnDuong · Answer

hi @yc151

Did you mean to attach an output file? Is it an excel output file or other format?

Would be best if you can attach the workflow (.YXZP) package.

Dawn.