|
|
1st July 2008, 05:56 PM
|
 |
Morrissey Rules.
|
|
Join Date: Jan 2008
Location: Old Swan, Liverpool.
Posts: 4,667
vCash: 800
|
|
|
Excel help
There is probably a very easy solution to this, but basically everytime I put a number into a cell in excel starting with a 0, the 0 dissapears.
e.g. if i type 0123 into excel in automatically turns to 123 and the 0 dissapears.
Its some type of formatting or something but I cant be arsed looking it up.
rep for the one genius who helps me.
__________________
Fernando Torres, turning straight men gay since July 2007
Su brazalete demostró que era un Rojo, Torres Torres
Nunca caminarás solo, Torres Torres
Compramos al chico en la España
El coge el balón, marcará otra vez
Fernando Torres, el número nueve del Liverpool
|
1st July 2008, 06:13 PM
|
 |
The Dark Knight.
|
|
Join Date: Oct 2004
Location: The gunline.
Posts: 3,358
vCash: 25
|
|
|
Re: Excel help
Quote:
Originally Posted by woo-lfc
There is probably a very easy solution to this, but basically everytime I put a number into a cell in excel starting with a 0, the 0 dissapears.
e.g. if i type 0123 into excel in automatically turns to 123 and the 0 dissapears.
Its some type of formatting or something but I cant be arsed looking it up.
rep for the one genius who helps me.
|
Not sure about that one mate, as for your other dilemma though, one sauce, per meal, per customer, bonne de douche everyone's a winner.
__________________
"I believe whatever doesn't kill you simply makes you... not dead".
|
1st July 2008, 06:20 PM
|
|
Morrissey Rules.
|
|
Join Date: Jan 2008
Location: Old Swan, Liverpool.
Posts: 4,667
vCash: 800
|
|
|
Re: Excel help
Quote:
Originally Posted by Ezekiel 25:17
Not sure about that one mate, as for your other dilemma though, one sauce, per meal, per customer, bonne de douche everyone's a winner.
|
Swerve that I'll just ring up and order some.
__________________
Fernando Torres, turning straight men gay since July 2007
Su brazalete demostró que era un Rojo, Torres Torres
Nunca caminarás solo, Torres Torres
Compramos al chico en la España
El coge el balón, marcará otra vez
Fernando Torres, el número nueve del Liverpool
|
1st July 2008, 06:37 PM
|
 |
Dirty Vcash
|
|
Join Date: Feb 2005
Location: Liverpool
Posts: 4,301
vCash: 625
|
|
|
Re: Excel help
I would help you but your offer of rep is defunct seeing as though you revenge negged me this morning.
Who looks silly now.
Look into data types, as there's no such thing as 0123 as far as Integers go, it's not a number. You need the box to accept the number as a string
|
1st July 2008, 07:49 PM
|
 |
TLW Season Ticket Holder
|
|
Join Date: Sep 2005
Posts: 222
vCash: 294
|
|
|
Re: Excel help
Format the cell to TEXT and it'll accept the zero.
|
1st July 2008, 08:07 PM
|
 |
Hermano
|
|
Join Date: Feb 2006
Location: Seasider
Posts: 8,105
vCash: 25
|
|
|
Re: Excel help
Don't bother with the formatting hassle, just enter a ' before your number and it automatically treats it as text:
'0123
You're welcome.
|
1st July 2008, 08:46 PM
|
 |
Dirk, actually
|
|
Join Date: Aug 2005
Location: You are
Posts: 15,570
vCash: 381
|
|
|
Re: Excel help
Quote:
Originally Posted by wiiksie
Don't bother with the formatting hassle, just enter a ' before your number and it automatically treats it as text:
'0123
You're welcome.
|
GOD DAMN 40 mins late. Another TNF geek hero window closes.
__________________
THUPERFAN
|
2nd July 2008, 12:37 AM
|
|
Morrissey Rules.
|
|
Join Date: Jan 2008
Location: Old Swan, Liverpool.
Posts: 4,667
vCash: 800
|
|
|
Re: Excel help
Quote:
Originally Posted by wiiksie
Don't bother with the formatting hassle, just enter a ' before your number and it automatically treats it as text:
'0123
You're welcome.
|
Cheers wilksie, repped.
__________________
Fernando Torres, turning straight men gay since July 2007
Su brazalete demostró que era un Rojo, Torres Torres
Nunca caminarás solo, Torres Torres
Compramos al chico en la España
El coge el balón, marcará otra vez
Fernando Torres, el número nueve del Liverpool
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
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
|
|
|
|
