View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default format a cell with a phone number - how?

Precede the number with an apostrophe (single quote) when typing the number.
--
Gary''s Student - gsnu2007L


"Martin ©¿©¬ @nohere.net" wrote:

Hi
I have a cell with a moblle phone number
0xxxxxxxxxx (11 numbers) & the 0 doesn't show?
Why is that & how do I fix please?
--
Martin
©¿©¬