New Posts  All Forums:Forum Nav:

excel

post #1 of 5
Thread Starter 
how do i make excel accept 0's infront of a number set, i.e. 0012123?
almost done(8800)
(13 items)
 
  
CPUMotherboardGraphicsRAM
c2d 6320 1.8@3150 1:1 Gigabyte DS3 x1950 pro 256 2G Patriot EP 800@900 
Hard DriveOptical DriveOSMonitor
80g Sata 7200rpm dvdrw/dl x2 xp pro 19" flat crt 
KeyboardPowerCaseMouse
generic okia 500W 712-4HLW-BK rosewill laser 
  hide details  
Reply
almost done(8800)
(13 items)
 
  
CPUMotherboardGraphicsRAM
c2d 6320 1.8@3150 1:1 Gigabyte DS3 x1950 pro 256 2G Patriot EP 800@900 
Hard DriveOptical DriveOSMonitor
80g Sata 7200rpm dvdrw/dl x2 xp pro 19" flat crt 
KeyboardPowerCaseMouse
generic okia 500W 712-4HLW-BK rosewill laser 
  hide details  
Reply
post #2 of 5
Select the cells you want to modify, right click, click on format cells, choose "Text".
Minotaur
(13 items)
 
  
CPUMotherboardGraphicsRAM
Core I5 2500K MSI P67A-GD53 2 X EVGA GTX 460 SLI G.Skill RIPJAWS 2*4Gb 1.3Ghz 
Hard DriveOptical DriveOSMonitor
WD: 2*500GB Raid0 + 2*2TB 2*DVD RW Optiarc+Samsung Windows 7 64-bit 24" ACER Widescreen HD 
KeyboardPowerCaseMouse
Microsoft Ergonomic 4000 Corsair HX620 Coolermaster HAF932 Advanced Ocz equalizer 
Mouse Pad
RatPadz GS 
  hide details  
Reply
Minotaur
(13 items)
 
  
CPUMotherboardGraphicsRAM
Core I5 2500K MSI P67A-GD53 2 X EVGA GTX 460 SLI G.Skill RIPJAWS 2*4Gb 1.3Ghz 
Hard DriveOptical DriveOSMonitor
WD: 2*500GB Raid0 + 2*2TB 2*DVD RW Optiarc+Samsung Windows 7 64-bit 24" ACER Widescreen HD 
KeyboardPowerCaseMouse
Microsoft Ergonomic 4000 Corsair HX620 Coolermaster HAF932 Advanced Ocz equalizer 
Mouse Pad
RatPadz GS 
  hide details  
Reply
post #3 of 5
or place a ' before the value.
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
Once again...
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 920 [4.28GHz, HT] Asus P6T + Broadcom NetXtreme II VisionTek HD5850 [900/1200] + Galaxy GT240 2x4GB G.Skill Ripjaw X [1632 MHz] 
Hard DriveOSMonitorKeyboard
Intel X25-M 160GB + 3xRAID0 500GB 7200.12 Window 7 Pro 64 Acer H243H + Samsung 226BW XARMOR-U9BL  
PowerCaseMouseMouse Pad
Antec Truepower New 750W Li Lian PC-V2100 [10x120mm fans] Logitech G9 X-Trac Pro 
  hide details  
Reply
post #4 of 5
LINK: http://support.microsoft.com/kb/81518

something i found for microsoft. you could also enter the number as text (put quotes around it) if you don't want to do arithmetic operations on it. hope this helps!
citrinitas
(14 items)
 
  
CPUMotherboardGraphicsRAM
QX9650 DFI LanParty DK P35-T2RS eVGA GTX260 SSC 4 x 1GB DDR2 Ballistix 1066MHz Dual Channel -D9MGH 
Hard DriveHard DriveOptical DriveOS
3 x 7200.11 500GB RAID 5 32GB Corsair V32 SSD (OS) none, and proud of it. ODD = obsolete tech! Win 7 
MonitorPowerCaseMouse
Acer X241W 24" WS TT Toughpower 700W Rocketfish + mods Logitech G9 
  hide details  
Reply
citrinitas
(14 items)
 
  
CPUMotherboardGraphicsRAM
QX9650 DFI LanParty DK P35-T2RS eVGA GTX260 SSC 4 x 1GB DDR2 Ballistix 1066MHz Dual Channel -D9MGH 
Hard DriveHard DriveOptical DriveOS
3 x 7200.11 500GB RAID 5 32GB Corsair V32 SSD (OS) none, and proud of it. ODD = obsolete tech! Win 7 
MonitorPowerCaseMouse
Acer X241W 24" WS TT Toughpower 700W Rocketfish + mods Logitech G9 
  hide details  
Reply
post #5 of 5
Thread Starter 
i got it, went a created custom cell format to 0000000 or as many digits as u need. thx anyway fellas
almost done(8800)
(13 items)
 
  
CPUMotherboardGraphicsRAM
c2d 6320 1.8@3150 1:1 Gigabyte DS3 x1950 pro 256 2G Patriot EP 800@900 
Hard DriveOptical DriveOSMonitor
80g Sata 7200rpm dvdrw/dl x2 xp pro 19" flat crt 
KeyboardPowerCaseMouse
generic okia 500W 712-4HLW-BK rosewill laser 
  hide details  
Reply
almost done(8800)
(13 items)
 
  
CPUMotherboardGraphicsRAM
c2d 6320 1.8@3150 1:1 Gigabyte DS3 x1950 pro 256 2G Patriot EP 800@900 
Hard DriveOptical DriveOSMonitor
80g Sata 7200rpm dvdrw/dl x2 xp pro 19" flat crt 
KeyboardPowerCaseMouse
generic okia 500W 712-4HLW-BK rosewill laser 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software