Overclock.net › Forums › Software, Programming and Coding › Other Software › Hhow to input 0 as the 1st # in Excel 2010...
New Posts  All Forums:Forum Nav:

Hhow to input 0 as the 1st # in Excel 2010...

post #1 of 5
Thread Starter 
Ugh...
I upped to Excel 2010 and I am LOST.
I'm trying to make a fax sheet to one of my wholesalers and he has a lot of items that start with number "0". When I type those items, like "012-3210" Excel gets rid of the first "0". I can't find the option to shut that off... any ideas for a spreadsheet nub?


TIA
Edited by DarthBaiter - 5/5/11 at 8:12am
Contender23
(15 items)
 
  
CPUMotherboardGraphicsRAM
FX 8150 ASRock 990FX Ex3 EVGA GeForce GTX 680 SC+ w/Backplate Mushkin Silverline 8GB (2 x 2GB) 240-Pin DDR3 S... 
Hard DriveOptical DriveCoolingOS
M4 128GB SSD LG Blu-Ray Rom Thermalright Archon Win 7 PRO 64bit 
MonitorKeyboardPowerCase
Asus VH236@1080p Filco Majestouch FKBN104M/EB Antec Earthwatt 650w Lian-Li PC-9F 
MouseMouse PadAudio
MS Sidewinder X8 Func 1030 Asus Xonar DX 
  hide details  
Reply
Contender23
(15 items)
 
  
CPUMotherboardGraphicsRAM
FX 8150 ASRock 990FX Ex3 EVGA GeForce GTX 680 SC+ w/Backplate Mushkin Silverline 8GB (2 x 2GB) 240-Pin DDR3 S... 
Hard DriveOptical DriveCoolingOS
M4 128GB SSD LG Blu-Ray Rom Thermalright Archon Win 7 PRO 64bit 
MonitorKeyboardPowerCase
Asus VH236@1080p Filco Majestouch FKBN104M/EB Antec Earthwatt 650w Lian-Li PC-9F 
MouseMouse PadAudio
MS Sidewinder X8 Func 1030 Asus Xonar DX 
  hide details  
Reply
post #2 of 5
Right click on the cell you are inputting data in, click format cells, and in the number tab, select text from the list. This should work.
My Rig
(16 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core 2 Duo E7600 @ 3.06Ghz Asus P5N-D 750i SLI ATi Radeon HD 6770 4 x 2GB Corsair Dominator DDR3 
Hard DriveHard DriveOptical DriveOS
2 x 500Gb Seagate Barracuda RAID 0 2TB Seagate Barracuda DVD+CD-RW Combo, DVD-RW Windows 8 Professional X64 
OSMonitorMonitorKeyboard
Ubuntu 12.10 x64 AOC F22S+ 22" HD 1080p 17" Monitor Logitech 
PowerCaseMouse
Powercool 850W Antec 902 Logitech 
  hide details  
Reply
My Rig
(16 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core 2 Duo E7600 @ 3.06Ghz Asus P5N-D 750i SLI ATi Radeon HD 6770 4 x 2GB Corsair Dominator DDR3 
Hard DriveHard DriveOptical DriveOS
2 x 500Gb Seagate Barracuda RAID 0 2TB Seagate Barracuda DVD+CD-RW Combo, DVD-RW Windows 8 Professional X64 
OSMonitorMonitorKeyboard
Ubuntu 12.10 x64 AOC F22S+ 22" HD 1080p 17" Monitor Logitech 
PowerCaseMouse
Powercool 850W Antec 902 Logitech 
  hide details  
Reply
post #3 of 5
IIRC its format cell and select general.
it looks alive
(17 items)
 
Sandy Transformed
(69 photos)
 
CPUMotherboardGraphicsRAM
i5 2500K [5ghz 1.44v 24/7] Asus Maximus IV Extreme SLI GTX 460 @ 920/1840/4100 [1.11v] 4GB Dominator GT @ 2133mhz CL8 [1.65v] 
Hard DriveHard DriveCoolingOS
Intel X25-M G2 80GB 3x Samsung F3 500GB RAID 0 EK Supreme HF Full Copper Windows 7 Ultimate 64bit 
MonitorPowerCaseAudio
LG42SL9500 42" 1080p [Surround Soon] XFX XXX Edition 650w Xigmatec Elysium JVC HA-RX700 [foam mod] 
  hide details  
Reply
it looks alive
(17 items)
 
Sandy Transformed
(69 photos)
 
CPUMotherboardGraphicsRAM
i5 2500K [5ghz 1.44v 24/7] Asus Maximus IV Extreme SLI GTX 460 @ 920/1840/4100 [1.11v] 4GB Dominator GT @ 2133mhz CL8 [1.65v] 
Hard DriveHard DriveCoolingOS
Intel X25-M G2 80GB 3x Samsung F3 500GB RAID 0 EK Supreme HF Full Copper Windows 7 Ultimate 64bit 
MonitorPowerCaseAudio
LG42SL9500 42" 1080p [Surround Soon] XFX XXX Edition 650w Xigmatec Elysium JVC HA-RX700 [foam mod] 
  hide details  
Reply
post #4 of 5
you can just type ' followed by the number ie to input 001 type '001
post #5 of 5
Thread Starter 
Thanks all...

+Rep to all
Contender23
(15 items)
 
  
CPUMotherboardGraphicsRAM
FX 8150 ASRock 990FX Ex3 EVGA GeForce GTX 680 SC+ w/Backplate Mushkin Silverline 8GB (2 x 2GB) 240-Pin DDR3 S... 
Hard DriveOptical DriveCoolingOS
M4 128GB SSD LG Blu-Ray Rom Thermalright Archon Win 7 PRO 64bit 
MonitorKeyboardPowerCase
Asus VH236@1080p Filco Majestouch FKBN104M/EB Antec Earthwatt 650w Lian-Li PC-9F 
MouseMouse PadAudio
MS Sidewinder X8 Func 1030 Asus Xonar DX 
  hide details  
Reply
Contender23
(15 items)
 
  
CPUMotherboardGraphicsRAM
FX 8150 ASRock 990FX Ex3 EVGA GeForce GTX 680 SC+ w/Backplate Mushkin Silverline 8GB (2 x 2GB) 240-Pin DDR3 S... 
Hard DriveOptical DriveCoolingOS
M4 128GB SSD LG Blu-Ray Rom Thermalright Archon Win 7 PRO 64bit 
MonitorKeyboardPowerCase
Asus VH236@1080p Filco Majestouch FKBN104M/EB Antec Earthwatt 650w Lian-Li PC-9F 
MouseMouse PadAudio
MS Sidewinder X8 Func 1030 Asus Xonar DX 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Hhow to input 0 as the 1st # in Excel 2010...