Wheels are Round (Comma Singles)

Format function to get the same result:.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies. I want to set a result with 2 digits after the comma. Was going to use InStr, Len and Mid, but this would make a lot of line just for this. Just did an edit because yes: The idea is that vba is american style centric. So if your numbers are coming in as 0, then it is a string and it needs to be converted to 0.

They are still strings so you will need convert them to singles or doubles. Sorry to be boring, but this looks like a job for a custom number format So you want something like this: Format function to get the same result: Dump your values onto the sheet, and then set the destination range's NumberFormat accordingly. I only included What's your decimal separator anyway?

Sign up or log in Sign up using Google. This should be an interesting thread - good call.

JuanTCB , Jan 25, My interest in this album was revived by a friend at work who was a teenager when this album was released, and was essentially her introduction to the band. I never really listened to it when it was released, despite buying it immediately. It has grown on me in the past few months of listening, and I quite enjoy it. Continental Drift is majestic.. Bought the cassette as a brand new release, I was a younger, thinner, 31 year-old. Anyway, I took to it immediately. Have since gotten whatever Japan pressing, know it doesn't matter as much since it's an all digital album, but still Great album, The Stones were dead and done before this.

The album that brought them back to life. They are still riding this wave. Yeah, its kind of 80's sounding, but love it. Its ok in spots, but sounds a bit forced.

See a Problem?

Another great comeback album, IMO. I love 'Almost hear you Sigh'. JA Fant , Jan 25, And having heard the alternate version with Mick doing lead vocals, they made a sublime choice in releasing it with Keith singing lead. It's okay, but far from essential a desciption that fits most of their albums since Exile. I caught the tour at the L. Colisseum with Living Color and G'n'R opening. At the time, I figured I better go since it might be my last chance to see the Stones. Little did I know. I thought it also sounded forced and suffers from 80's production values. My favorite Stones album!

It never seems too popular, but I love it! I'm a big Keith vocal fan, and "Slipping Away" is to me the ultimate Keith sung track! I can't wait until we get to it! Wonderful idea for a thread! Love it when Keith sings - First the sun and then the moon, one of them will be 'round soon!

Your Answer

Oh crud, it's the last track on the album Pepper , Jan 25, Last major release I bought on vinyl. It got played a lot when new. Mixed Emotion was pretty good. Can't Be Seen is embarrasing. Jim in Houston , Jan 25, What a excellent comeback LP.

Some great tracks recorded and many left off the final release. That track had all the traditional elements of a classic old ballad done by The Stones. This paid a perfect tribute to their early Chess period recordings.