Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep zeros at the begining of a number
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?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to keep zeros at the begining of a number
Try it this way:
=A2 & B2 & TEXT(C2,"0000000") The zeros in the TEXT function determine how many characters to include and will fill with leading zeros where necessary. Hope this helps. Pete "sockst" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
change negative sign from end of the number to the begining | Excel Discussion (Misc queries) | |||
option to keep zero at begining of number | Excel Discussion (Misc queries) | |||
how to add symbol automatically at begining and end | Excel Discussion (Misc queries) | |||
Preceding a number by zeros, that is still a number | Excel Worksheet Functions |