Thread: How to keep zeros at the begining of a number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Moseley Alan Moseley is offline
external usenet poster
  
Posts: 75
Default How to keep zeros at the begining of a number
I have formatted A2, B2 and C2 as text and entered in your suggested values.
In D2 I have entered:-
=A2 & B2 & C2
Your required value is returned.

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"sockst" wrote:

When I merge data together the zeros are removed from the begining of the data.
EX SSSD 001234 0 , when merged by =(cell "A2" & cell "B2" & cell "c2")
the zero are removed making it: "SSSD1234" when it needs to be "SSSD0012340"

How do I maintain the zeros in the data I want to merge??
Reply With QuoteReply With Quote