problem format or something else ))

[ytrewq1308]

A B =A&"-"&B
2546.0 2550.0 2546-2550

but I want see(2546.0-2550.0) but function (&) don't use format

HELP

 

[muddan madhu]

try this ="("&A1&"-"&B1&")"

 

[Niek Otten]

Formula:

=TEXT(A1,"0.0")&"-"&TEXT(B1,"0.0")

Kind regards,

Niek Otten
Microsoft MVP - Excel
|
| A B =A&"-"&B
| 2546.0 2550.0 2546-2550
|
| but I want see(2546.0-2550.0) but function (&) don't use format
|
| HELP

 

[Brad]

=TEXT(B6,"#.0")&"-"&TEXT(B6,"#.0")

 

[Brad]

My first post had two "B"'s the first "B" shouuld be an "A"