Help & FAQs    Search BCF    Members    Groups    Events Calendar
Resend my activation email : Register : Log in 
BCF: Bike Chat Forums


Microsoft excel - anyone know how to...

 Reply to topic
Bike Chat Forums Index -> Random Banter
View previous topic : View next topic  
Author Message

Mr Nice Guy
World Chat Champion



Joined: 18 Jul 2007
Karma :
PostPosted: 14:56 - 13 May 2009    Post subject: Microsoft excel - anyone know how to... Reply with quote
I need to format the cell in order that it will show the value 000001 (and so on - military shite so the zero's are relevant) - but it obviously just switches it to 1 (and so on).

Can't for the life of me mind how to Embarassed
____________________
Suzuki GSX-R750K4 ~ Mivv GP
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Mr Nice Guy
World Chat Champion



Joined: 18 Jul 2007
Karma :
PostPosted: 14:58 - 13 May 2009    Post subject: Reply with quote
Bell end - wrong forum sorry!! (If anyone can move it will be appreciated)
____________________
Suzuki GSX-R750K4 ~ Mivv GP
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

ncrn
World Chat Champion



Joined: 24 May 2006
Karma :
PostPosted: 15:01 - 13 May 2009    Post subject: Reply with quote
Right click in the cell and hit format cell, then go to custom and type in 000000 for however many 0's you need and that should do it for you.
____________________
Past: 55 Sym Jet, 91 ZZR250, 03 NSR125R. Present: 97 ER-5.
https://www.nsr125.co.uk - NSR Owners forum.
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Mr Nice Guy
World Chat Champion



Joined: 18 Jul 2007
Karma :
PostPosted: 15:03 - 13 May 2009    Post subject: Reply with quote
Thanks Karma Thumbs Up
____________________
Suzuki GSX-R750K4 ~ Mivv GP
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Charlie
World Chat Champion



Joined: 27 May 2007
Karma :
PostPosted: 15:07 - 13 May 2009    Post subject: Reply with quote
Right click cell, format cell, custom

Then enter the size of the number (enter six 0s for your number).

Thumbs Up

Edit: To slow Thumbs Down Sad
____________________
Past: Honda x8rs, Honda City fly, Honda Hornet 250, Honda VFR750, Yamaha xt600e.
Current: Honda CBR929RR & Yamaha XT660Z Tenere
 Back to top
View user's profile Send private message You must be logged in to rate posts

Davie_G71
World Chat Champion



Joined: 18 Sep 2007
Karma :
PostPosted: 15:26 - 13 May 2009    Post subject: Reply with quote
OT - but MNG do you park your bike on Cochrane street in the City Centre?
____________________
Suzuki GSXR600 SRAD, 1997 & Kawasaki Z1000, 2003.
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Mr Nice Guy
World Chat Champion



Joined: 18 Jul 2007
Karma :
PostPosted: 15:39 - 13 May 2009    Post subject: Reply with quote
Nah Davie, I've seen that one a few times though (today for a matter of fact as I got stuck in traffic there in the cage)...its the 600 in all yellow.
____________________
Suzuki GSX-R750K4 ~ Mivv GP
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Davie_G71
World Chat Champion



Joined: 18 Sep 2007
Karma :
PostPosted: 15:45 - 13 May 2009    Post subject: Reply with quote
Aye, i got stuck just beside it too in the car this morning about quarter to 9, thought it was yours.
____________________
Suzuki GSXR600 SRAD, 1997 & Kawasaki Z1000, 2003.
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Mr Nice Guy
World Chat Champion



Joined: 18 Jul 2007
Karma :
PostPosted: 16:15 - 13 May 2009    Post subject: Reply with quote
Cracking day and we're both in cages Crying or Very sad
____________________
Suzuki GSX-R750K4 ~ Mivv GP
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Davie_G71
World Chat Champion



Joined: 18 Sep 2007
Karma :
PostPosted: 16:25 - 13 May 2009    Post subject: Reply with quote
I know, i have to drop my daughter off in the morning and take the wife into own 3 days a week - what's your excuse?
____________________
Suzuki GSXR600 SRAD, 1997 & Kawasaki Z1000, 2003.
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

ncrn
World Chat Champion



Joined: 24 May 2006
Karma :
PostPosted: 17:46 - 13 May 2009    Post subject: Reply with quote
Mr Nice Guy wrote:
Thanks Karma Thumbs Up


No worries, glad to help Thumbs Up.
____________________
Past: 55 Sym Jet, 91 ZZR250, 03 NSR125R. Present: 97 ER-5.
https://www.nsr125.co.uk - NSR Owners forum.
 Back to top
View user's profile Send private message Send e-mail You must be logged in to rate posts

Paivi
World Chat Champion



Joined: 30 Sep 2005
Karma :
PostPosted: 12:28 - 16 May 2009    Post subject: Reply with quote
Or you can type it with ' in front of the number, i.e., '000001.
____________________
My other bike's a Monster... Wink
 Back to top
View user's profile Send private message You must be logged in to rate posts

The Shaggy D.A.
Super Spammer



Joined: 12 Sep 2008
Karma :
PostPosted: 14:26 - 16 May 2009    Post subject: Reply with quote
Paivi wrote:
Or you can type it with ' in front of the number, i.e., '000001.


But then it will be treated as text, and left justified. Might as well format it properly.
____________________
Chances are quite high you are not in my Monkeysphere, and I don't care about you. Don't take it personally.
Currently : Royal Enfield 350 Meteor
Previously : CB100N > CB250RS > XJ900F > GT550 > GPZ750R/1000RX > AJS M16 > R100RT > Bullet 500 > CB500 > LS650P > Bullet Electra X & YBR125 > Bullet 350 "Superstar" & YBR125 Custom > Royal Enfield Classic 500 Despatch Limited Edition (28 of 200) & CB Two-Fifty Nighthawk > ER5
 Back to top
View user's profile Send private message You must be logged in to rate posts

Paivi
World Chat Champion



Joined: 30 Sep 2005
Karma :
PostPosted: 14:35 - 16 May 2009    Post subject: Reply with quote
The Shaggy D.A. wrote:
Paivi wrote:
Or you can type it with ' in front of the number, i.e., '000001.


But then it will be treated as text, and left justified. Might as well format it properly.

Ah, true. Forget I spoke... Embarassed
____________________
My other bike's a Monster... Wink
 Back to top
View user's profile Send private message You must be logged in to rate posts
Old Thread Alert!

The last post was made 17 years, 118 days ago. Instead of replying here, would creating a new thread be more useful?
  Display posts from previous:   
This page may contain affiliate links, which means we may earn a small commission if a visitor clicks through and makes a purchase. By clicking on an affiliate link, you accept that third-party cookies will be set.

Post new topic   Reply to topic    Bike Chat Forums Index -> Random Banter All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Read the Terms of Use! - Powered by phpBB © phpBB Group
 
Debug Mode: ON - Server: birks (www) - Page Generation Time: 0.08 Sec - Server Load: 0.51 - MySQL Queries: 14 - Page Size: 82.24 Kb