combine data in two cells into a third cell

[ordnance1]

In cell A1 is a number(9), in cell A2 is a number (0001). Is there any way to
get cell A3 to show the result 9-0001?

 

[muddan madhu]

try this

in A3 put this =A1&"-"&A2

 

[Max]

In cell A1 is a number(9), in cell A2 is a number (0001). Is there any way to
get cell A3 to show the result 9-0001?

Try in A3: =A1&"-"&TEXT(A2,"0000")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100 Files:360 Subscribers:56
xdemechanik
---

 

[Max]

in A3 put this =A1&"-"&A2
... but if A2 actually contained an underlying value: 1
then the result in A3 would be: 9-1 ?
OP's poser is a tricky one
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,100, Files:360, Subscribers:56
xdemechanik
---