cancel
Showing results for 
Search instead for 
Did you mean: 

'003338366400' converts to 2147483647

RADSr
Captain
Captain

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

 

formula_issue.gif

 

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

-- IncortaOne@PMsquare.com --
3 REPLIES 3

JoeM
Community Manager
Community Manager

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

RADSr
Captain
Captain

Bingo!    ( and Community beat support  😉  ) 

-- IncortaOne@PMsquare.com --

JoeM
Community Manager
Community Manager

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