Forum Discussion
Number format
As a Realtor I have, over the years, downloaded bulk MLS data for offline processing in Excel for the benefit of my buyer and seller clients. There was never a problem until the MLS service (Garden S...
Since your data format appears so consistent, you could also use the MID function to 'top and tail' the text. I use Names to reference data so I would define 'rentPrice' to refer to
= VALUE( MID( input, 2, LEN(input)-2 ) )
That tucks the boring junk out of sight and the formula
= SUM( rentPrice )
is clear in terms of its business intent.