'003338366400' converts to 2147483647

[RADSr]

I think I've seen this before and asked on the old community, but how can I get a value such as this string

'003338366400' to appear and be treated as this number 3338366400 ?   

The actual formula does a replace to get rid of dashes and a trim to get rid of spaces or hidden characters, but the issue exists even if I hard code the string into the formula column.  

int() returns 2147483647  ( which is a cool number and all, but it's not the one I need )  and double() returns 3.3383664E9 which looks close, but the formatting options are either 1) no formatting or 2) time/date based which ... don't change the appearance at all

Ticket logged, but it's a sev 3 so Community has a real chance to win this race!   😉    

 

[JoeM · Accepted solution]

@RADSr - I got this. Did you try long()?

[RADSr]

Bingo!    ( and Community beat support  😉  ) 

[JoeM]

The number 2147483647 truly is special. I believe -2147483647 to 2147483647 can be returned with int().