Thread: How do I keep the 0 at the beginning of my order? (098523)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VBA Noob VBA Noob is offline
external usenet poster
  
Posts: 1
Default How do I keep the 0 at the beginning of my order? (098523)

Three ways

1) Format the cell as text
2) Enter ' before the number
3) Enter the text with a space lile a mobile number 07753 666 111

All three ways converts the number to text

VBA noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564501

Reply With QuoteReply With Quote