ScoobyNet.com - Subaru Enthusiast Forum

Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

MS Excel

Thread Tools
 
Search this Thread
 
Old 12 September 2003, 11:51 AM
  #1  
Buckrogers
Scooby Regular
Thread Starter
 
Buckrogers's Avatar
 
Join Date: Aug 2003
Posts: 2,644
Likes: 0
Received 0 Likes on 0 Posts
Exclamation
Hi

I'm trying to format a single cell in Excel, so that when you enter just a numeric number, eg 34, 34kgs is displayed in the cell.

I know that it can be done, under format cells / number / custom as I have done it before years ago, but now cannot remember, doh!

(It was done on a pc that I no longer have access to).

Thanks for any help in advance.

Buck
Buckrogers is offline  
Reply Like
Old 12 September 2003, 11:58 AM
  #2  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Post
Format
Cells
Number
Custom
In the 'Type' box put something like '00 Kg'


DJ Dunk is offline  
Reply Like
Old 12 September 2003, 12:02 PM
  #3  
Buckrogers
Scooby Regular
Thread Starter
 
Buckrogers's Avatar
 
Join Date: Aug 2003
Posts: 2,644
Likes: 0
Received 0 Likes on 0 Posts
Post
It wont accept 00
Buckrogers is offline  
Reply Like
Old 12 September 2003, 12:04 PM
  #4  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Post
Works on mine MS Excel 2000

What happens when you put 00 Kg ?

[Edited by DJ Dunk - 9/12/2003 12:06:19 PM]
DJ Dunk is offline  
Reply Like
Old 12 September 2003, 12:07 PM
  #5  
Buckrogers
Scooby Regular
Thread Starter
 
Buckrogers's Avatar
 
Join Date: Aug 2003
Posts: 2,644
Likes: 0
Received 0 Likes on 0 Posts
Post
Ahh, I was trying with kgs. Works fine with just kg.

Nice one, thanks DJ Junk.

Buck
Buckrogers is offline  
Reply Like
Old 12 September 2003, 12:08 PM
  #6  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Post
No probs. It's DJ Dunk BTW
DJ Dunk is offline  
Reply Like
Old 12 September 2003, 12:10 PM
  #7  
djuk
Scooby Regular
 
djuk's Avatar
 
Join Date: Jun 2002
Location: Berkshire
Posts: 1,280
Likes: 0
Received 0 Likes on 0 Posts
Post
Actually, if you use 00 "KGs" it works Just incase you were desperate to have kgs
djuk is offline  
Reply Like

Trending Topics

Old 12 September 2003, 12:12 PM
  #8  
Buckrogers
Scooby Regular
Thread Starter
 
Buckrogers's Avatar
 
Join Date: Aug 2003
Posts: 2,644
Likes: 0
Received 0 Likes on 0 Posts
Post
LOL, soz mate, no dig intended!!!

I almost spilt me coffee when I read that, how rude could I be!
Buckrogers is offline  
Reply Like
Old 12 September 2003, 12:14 PM
  #9  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Post
LOL
DJ Dunk is offline  
Reply Like
Old 12 September 2003, 12:16 PM
  #10  
Buckrogers
Scooby Regular
Thread Starter
 
Buckrogers's Avatar
 
Join Date: Aug 2003
Posts: 2,644
Likes: 0
Received 0 Likes on 0 Posts
Post
Cheers djuk, that works fine for me also.
Buckrogers is offline  
Reply Like
Old 12 September 2003, 12:21 PM
  #11  
Figment
Scooby Regular
 
Figment's Avatar
 
Join Date: Jul 2001
Location: deep inside your imagination
Posts: 24,057
Likes: 0
Received 0 Likes on 0 Posts
Post
Can't get either option to work in XP
Figment is offline  
Reply Like
Old 12 September 2003, 12:53 PM
  #12  
markr1963
Scooby Regular
 
markr1963's Avatar
 
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes on 0 Posts
Thumbs up
This works on mine (WinXP/Office XP)
markr1963 is offline  
Reply Like
Old 12 September 2003, 02:06 PM
  #13  
Figment
Scooby Regular
 
Figment's Avatar
 
Join Date: Jul 2001
Location: deep inside your imagination
Posts: 24,057
Likes: 0
Received 0 Likes on 0 Posts
Post
D'oh. Didn't think to put the text in inverted commas

Thanks, I may remember that when the time comes that I need it.
Figment is offline  
Reply Like
Old 12 September 2003, 02:31 PM
  #14  
Redkop
Scooby Regular
 
Redkop's Avatar
 
Join Date: Oct 2001
Posts: 11,403
Likes: 0
Received 0 Likes on 0 Posts
Post
I almost spilt me coffee when I read that
I did too
Redkop is offline  
Reply Like
Old 12 September 2003, 03:46 PM
  #15  
Redkop
Scooby Regular
 
Redkop's Avatar
 
Join Date: Oct 2001
Posts: 11,403
Likes: 0
Received 0 Likes on 0 Posts
Post
Hi Dunk, I am fine thanks and yep I did celebrate, must admit, didn't think I would be, going by previous games
Redkop is offline  
Reply Like
Old 12 September 2003, 03:49 PM
  #16  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Post
MUST beat the Burn this weekend . . . won't hear the last of it from my mate otherwise

Take care, Dunk
DJ Dunk is offline  
Reply Like
Old 12 September 2003, 03:50 PM
  #17  
MichelleWRX1994
Scooby Regular
 
MichelleWRX1994's Avatar
 
Join Date: Oct 2001
Posts: 19,645
Likes: 0
Received 0 Likes on 0 Posts
Wink
Lynne dropped me this link and I pretty much followed suit, spitting out my Archers all over the keyboard and screen.

DJ Duck did you say Lynne?
MichelleWRX1994 is offline  
Reply Like
Old 12 September 2003, 03:52 PM
  #18  
Redkop
Scooby Regular
 
Redkop's Avatar
 
Join Date: Oct 2001
Posts: 11,403
Likes: 0
Received 0 Likes on 0 Posts
Post
Away form is better - so there's hope Dunk

Chelle I actually said Duk

Redkop is offline  
Reply Like
Old 12 September 2003, 04:21 PM
  #19  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Post
Archers . . . at this time of day . . . with your reputation

Hmmm, not such a bad idea after all . . .

Signing out for a wee drinkie . . . DJ Duk . . . Junk . . . Ah, whatever

Take care ladies
DJ Dunk is offline  
Reply Like
Old 09 December 2003, 03:12 PM
  #20  
DJ Dunk
Moderator
Support Scoobynet!
iTrader: (5)
 
DJ Dunk's Avatar
 
Join Date: Nov 2001
Location: Not all those who wander are lost
Posts: 17,863
Received 0 Likes on 0 Posts
Talking
I almost spilt me coffee when I read that

I did too
Thanks Lynne, I knew I could rely on you Hope you are well and have recovered from celebrating walking all over the toffees

[Edited by DJ Dunk - 9/12/2003 3:12:49 PM]
DJ Dunk is offline  
Reply Like
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
BUGEYE PRODRIVE STI BREAKING(rota's/racebox/whiteline/cusco/prodrive styling/6speed+
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
BUGEYE PRODRIVE STI BREAKING(bc br's/rota's/afterburner/6speed/ej207/brembos/prodrive
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
Lateral MD321H Billet turbo
leg200
Subaru Parts
5
07 October 2015 07:31 AM
Newage Hayward and Scott 2.5" exhaust system
has-scooby
Subaru Parts
4
06 October 2015 03:47 PM
Phase 2 (v5) heads on phase 1.5 block. Anyone done this before???
bluebullet29
General Technical
9
05 October 2015 02:17 PM
Back to Subforum
Computer & Technology Related
View Next Unread
Why do I get "=A3" on my emails?




Advanced Search
Quick Reply: MS Excel


Reply Closed Thread Share
Forum Jump

All times are GMT +1. The time now is 11:30 PM.