Text to number

[mtapp]

I have this formula which returns the correct data (in text format), but I need it in a number format and can't figure out how to convert from text to formula

=if(and({Category}="Convention/Tradeshow (CT)",{Out Date}>10/1/18),{Attendance Formula for Reporting}*2814,if(and({Category}="Convention Without Exhibits (CW)",{Out Date}>10/01/18),{Attendance Formula for Reporting}*2814, if(and({Category}="Conference (CF)",{Out Date}>10/1/18),{Attendance Formula for Reporting}*2814, if(and({Category}="Convention/Tradeshow - Hybrid (CH)",{Out Date}>10/1/18),({Attendance Formula for Reporting}/2*2814)))))

 

[Legacy 143009]

Try,

=if(and({Category}="Convention/Tradeshow (CT)",{Out Date}>10/1/18),{Attendance Formula for Reporting}*2814,if(and({Category}="Convention Without Exhibits (CW)",{Out Date}>10/01/18),{Attendance Formula for Reporting}*2814, if(and({Category}="Conference (CF)",{Out Date}>10/1/18),{Attendance Formula for Reporting}*2814, if(and({Category}="Convention/Tradeshow - Hybrid (CH)",{Out Date}>10/1/18),({Attendance Formula for Reporting}/2*2814)))))+0

 

[Norie]

What value does that formula return?

 

[mtapp]

It is returning the correct number but in a text format.
7000000 instead of 7,000,000.00
7280000 instead of 7,280,000.00

 

[mtapp]

One thing I just found is that if I remove the date parameter the result is a numeric value

 

[Norie]

The date parameters in the formula aren't correct.

Something like 10/1/18 is regarded as 10 divided by 1 divided by 18, i.e. not a date.