automatically reformatting data

[amesik...@gmail.com]

Hi all,

It doesn't look like the issue has come up yet but I was wondering if anyone was experiencing this problem.  I grouped my raw data into categories before importing  (18-40, 41-60, etc).  I did this with several different columns and all are working fine except one.  It keeps reformatting it as 0 or 100.  When I try to manually put in the data, it doesn't accept my entry.  Is this because I am using special characters such as the "less than" and "greater than/equal to" signs?

Thanks for your help.

[Evan Miller]

Hi Amesika,

What file format are you importing from? I think what's happening is that one column is being treated as numeric instead of text, and therefore only accepts numeric input. If you're using CSV, Wizard uses the value in the first row of data to decide whether the column is numeric or not. If you're using XLS or XLSX, Wizard will examine the cell formatting. So "18-40" is being treated as text, but "100" looks like a number so Wizard assumes the rest of the column is numbers. Does that make sense?

Evan

--
You received this message because you are subscribed to the Google Groups "Wizard User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wizard-users...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Evan Miller
http://www.evanmiller.org/

[amesik...@gmail.com]

Hi,

Thanks! That made sense and I was able to get it to work.  By the way, I am using XLS.

Amesika

[Evan Miller]

Great! Glad you got it figured out. Let me know if you hit any other snags.

Evan