d4za
Member
Registered: 18th Oct 06
Location: Bloxwich, West Midlands
User status: Offline
|
i need to insert a few different contact numbers into a spreadsheet but everytime I try to start the area code, the starting zero disappears. How do I format the cells to allow me to make this work?
|
Tommy L
Member
Registered: 21st Aug 06
Location: Northampton Drives: Audi wagon
User status: Offline
|
hyphen infront of the 0
ie. '01234 265852
|
Tommy L
Member
Registered: 21st Aug 06
Location: Northampton Drives: Audi wagon
User status: Offline
|
or right click format cells>custom>click the 0>then in type add 11 zeros
|
Fad
Member
Registered: 1st Feb 01
Location: Dartford Kent Drives: 330cd
User status: Offline
|
"Format cells" and select the "general" item.
|
d4za
Member
Registered: 18th Oct 06
Location: Bloxwich, West Midlands
User status: Offline
|
cheers for the replies, problem fixed now 
|
Ian
Site Administrator
Registered: 28th Aug 99
Location: Liverpool
User status: Offline
|
quote:
Originally posted by corsa_tomtom
hyphen infront of the 0
ie. '01234 265852
That's an apostrophe. A hyphen is next to zero -
You can also put a space in there and it won't format it as a number.
|
Tommy L
Member
Registered: 21st Aug 06
Location: Northampton Drives: Audi wagon
User status: Offline
|
My bad 
|
pow
Premium Member
Registered: 11th Sep 06
Location: Hazlemere, Buckinghamshire
User status: Offline
|
quote:
Originally posted by Fad
"Format cells" and select the "general" item.
Or text item 
|
