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

 

Format
Cells
Number
Custom
In the 'Type' box put something like '00 Kg'

 

It wont accept 00

 

Works on mine MS Excel 2000

What happens when you put 00 Kg ?

[Edited by DJ Dunk - 9/12/2003 12:06:19 PM]

 

Ahh, I was trying with kgs. Works fine with just kg.

Nice one, thanks DJ Junk.

Buck

 

No probs. It's DJ Dunk BTW

 

Actually, if you use 00 "KGs" it works Just incase you were desperate to have kgs

 

LOL, soz mate, no dig intended!!!

I almost spilt me coffee when I read that, how rude could I be!

 

LOL

 

Cheers djuk, that works fine for me also.

 

Can't get either option to work in XP

 

This works on mine (WinXP/Office XP)

 

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.

 

I did too

 

Hi Dunk, I am fine thanks and yep I did celebrate, must admit, didn't think I would be, going by previous games

 

MUST beat the Burn this weekend . . . won't hear the last of it from my mate otherwise

Take care, Dunk

 

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?

 

Away form is better - so there's hope Dunk

Chelle I actually said Duk

 

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

 

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]