|
|
1st July 2008, 06:56 PM
|
 |
Wooooooooooooooo!
|
|
Join Date: Jan 2008
Location: Old Swan, Liverpool.
Posts: 7,637
vCash: 0
|
|
|
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, 07:13 PM
|
 |
Spiderman.
|
|
Join Date: Oct 2004
Location: The gunline.
Posts: 4,085
vCash: 25
|
|
|
Re: Excel help
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.
__________________
Does whatever I spider can.
|
1st July 2008, 07:20 PM
|
|
Wooooooooooooooo!
|
|
Join Date: Jan 2008
Location: Old Swan, Liverpool.
Posts: 7,637
vCash: 0
|
|
|
Re: Excel help
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, 07:37 PM
|
 |
Chainy's mentor
|
|
Join Date: Feb 2005
Location: Liverpool
Posts: 5,717
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
__________________
"I agree completely with what Leeson just said" - Dave Usher ( 02/12/08 )
|
1st July 2008, 08:49 PM
|
 |
TLW Season Ticket Holder
|
|
Join Date: Sep 2005
Posts: 328
vCash: 244
|
|
|
Re: Excel help
Format the cell to TEXT and it'll accept the zero.
|
1st July 2008, 09:07 PM
|
 |
Hermano
|
|
Join Date: Feb 2006
Location: Seasider
Posts: 8,710
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, 09:46 PM
|
 |
A Sure Thing
|
|
Join Date: Aug 2005
Location: You are
Posts: 17,508
vCash: 25
|
|
|
Re: Excel help
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.
__________________
I eat spiders
|
2nd July 2008, 01:37 AM
|
|
Wooooooooooooooo!
|
|
Join Date: Jan 2008
Location: Old Swan, Liverpool.
Posts: 7,637
vCash: 0
|
|
|
Re: Excel help
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
|
|
|
|
