| Gaming, IT, Multimedia & Music Please use this forum to discuss Gaming, IT, Multimedia & Music. |
 |
31st January 2008, 15:14
|
#1
|
|
Saxperience Post Whore
Join Date: Sep 2006
Location: Tamworth
Posts: 9,581
Car(s): VTR, RX8
|
microsoft excel
Have to do a telephone list for work and everytime i type 0 it disappears can anyone help please?
__________________
WOOOOOO!
|
|
|
|
31st January 2008, 15:16
|
#2
|
|
Saxperience Addict
Join Date: Mar 2006
Location: Leeds
Posts: 10,616
Car(s): Golf
|
set the cells to accept text not number, it wont regester the zero
right click, format cells, then pick text
|
|
|
|
|
31st January 2008, 15:16
|
#3
|
|
Saxperience Post Whore
Join Date: Sep 2006
Location: Tamworth
Posts: 9,581
Car(s): VTR, RX8
|
ok thanks dude
__________________
WOOOOOO!
|
|
|
|
|
31st January 2008, 15:18
|
#4
|
|
Saxperience Forum Bum
Join Date: Mar 2007
Location: Maidstone, Kent
Posts: 4,121
Car(s): Mk2 Posi Blue 1.1
|
Yep, right click in the cell and goto format. In one of the tabs there, there is an option for cell type. Change it from number to text. Press OK once you've done that.
Once you've done that click (and hold) the black dot in the bottom right of the cell, and drag it down the column (presuming that they're all in the same column) and it will apply the same settings to all the cells that you selected
|
|
|
|
|
31st January 2008, 15:18
|
#5
|
|
Saxperience Hardcore!
Join Date: Jun 2004
Location: Newtowntowntowntowntown
Posts: 17,562
Car(s): Civic Type R EP3
|
Deffo a virus.....
Can only be solved by pushing monitor off desk and on too floor.....x10
__________________
Star in the Hood
|
|
|
|
|
31st January 2008, 15:18
|
#6
|
|
Saxperience Post Whore
Join Date: Sep 2006
Location: Tamworth
Posts: 9,581
Car(s): VTR, RX8
|
ok its all done and dusted now thanks for your help
__________________
WOOOOOO!
|
|
|
|
|
31st January 2008, 15:19
|
#7
|
|
Saxperience Addict
Join Date: Mar 2006
Location: Leeds
Posts: 10,616
Car(s): Golf
|
Quote:
Originally Posted by AdamW
Deffo a virus.....
Can only be solved by pushing monitor off desk and on too floor.....x10
|
your dying to be a pc tech
admit it adam
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT. The time now is 11:55.
|
Linear Mode
