Solved Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy)

S

support4u

New member
Member
Local time
10:52 PM
Messages
43
Yo folks,

Annoying little thing in excel,
I want to show the date exactly like this: 00-00-0000 (08-03-2012)(dd-mm-yyyy)
Instead excel removes the zero's like this: 0-0-0000 (8-3-2012) (d-m-yyyy)

Is it possible to keep the zero's?

Thanks in advanced,
 

My Computer My Computer

At a glance

Windows 7Intel Core 2 Quad Q6600OCZ2N1066SR2GK 4gb totalSapphire ATI HD5770,1GB
Computer Manufacturer/Model Number
-
OS
Windows 7
CPU
Intel Core 2 Quad Q6600
Motherboard
ASUS P5N32e SLI
Memory
OCZ2N1066SR2GK 4gb total
Graphics Card(s)
Sapphire ATI HD5770,1GB
Sound Card
Creative Sounblaster Live!
Monitor(s) Displays
Samsung Syncmaster 206BW
Hard Drives
1x WD Raptor 250gb
2x 500 gb Hitachi Deskstar
PSU
-
Case
Coolermaster Cosmos
Cooling
-
what i think you want is to format the cells with a custom format...

Use dd/mm/yyyy for the Type

edit: use dd-mm-yyyy for the Type
 
Last edited:

My Computer My Computer

At a glance

Multi-Boot W7_Pro_x64 W8.1_Pro_x64 W10_Pro_x6...AMD Athlon II x4 6206GB GSkill DDR2 800AMD 4670 GPU + AMD 4200 IGP
Computer type
PC/Desktop
Computer Manufacturer/Model Number
home built
OS
Multi-Boot W7_Pro_x64 W8.1_Pro_x64 W10_Pro_x64 +Linux_VMs +Chromium_VM
CPU
AMD Athlon II x4 620
Motherboard
Gigabyte GA-MA785G-UD3H
Memory
6GB GSkill DDR2 800
Graphics Card(s)
AMD 4670 GPU + AMD 4200 IGP
Sound Card
on board Realtek ALC889A
Monitor(s) Displays
RCA 40" LCD TV, Insignia 32" LCD TV, HP 15" LCD monitor
Screen Resolution
1680 x 1050
Hard Drives
OCZ Vertex 3 120GB,
Samsung F3 1TB (3),
Several others - WD, Seagate, Hitachi, ...
PSU
Corsair 500 W
Case
Rosewill mid tower
Cooling
CM 90mm rifle
Keyboard
Gyration wireless, Logitech wireless, Dell USB wired
Mouse
Gyration wireless, Logitech wireless, V7 USB wired
Internet Speed
Spectrum - 100Mbps D / 10Mbps U
Antivirus
Avast, MBAM3, EMET, WinPatrol
Browser
Pale Moon, Firefox, IE
Other Info
2 multi-boot PC's
Mainly HTPC/Office/Gen purpose (no gaming).
Trendnet USB KVM.
LG DVD burner/Blue Ray Player.
Tray system for removable SATA backup drives.

Not currently OCd, under-volted.
I use Hybrid sleep, rarely re-boot or shutdown.

Hauppauge HD-PVR, Avermedia PCIe TV Tuner, Hauppauge PCI TV Tuner.
Works like a charm.
Completely overlookt the custom option.
Thanks!
 

My Computer My Computer

At a glance

Windows 7Intel Core 2 Quad Q6600OCZ2N1066SR2GK 4gb totalSapphire ATI HD5770,1GB
Computer Manufacturer/Model Number
-
OS
Windows 7
CPU
Intel Core 2 Quad Q6600
Motherboard
ASUS P5N32e SLI
Memory
OCZ2N1066SR2GK 4gb total
Graphics Card(s)
Sapphire ATI HD5770,1GB
Sound Card
Creative Sounblaster Live!
Monitor(s) Displays
Samsung Syncmaster 206BW
Hard Drives
1x WD Raptor 250gb
2x 500 gb Hitachi Deskstar
PSU
-
Case
Coolermaster Cosmos
Cooling
-
You must log in or register to reply here.
Back
Top