Thread: Arrrggggh - Microsoft Excel
View Single Post
  #6  
Old 02.04.2014, 22:12
mirfield's Avatar
mirfield mirfield is offline
Forum Legend
  
Join Date: Apr 2007
Location: North Yorkshire
Posts: 8,729
Groaned at 53 Times in 47 Posts
Thanked 9,942 Times in 3,654 Posts
mirfield has a reputation beyond reputemirfield has a reputation beyond reputemirfield has a reputation beyond reputemirfield has a reputation beyond reputemirfield has a reputation beyond reputemirfield has a reputation beyond repute
Re: Arrrggggh - Microsoft Excel
Quote:
me.anon
 View Post
Yes. Frustrating isn't it. Just try to put in some telephone numbers and watch how it strips away all those 'unwanted' preceding zeroes.
Just add a ' before any number you want to be treated as text.
Reply With Quote