problem format or something else ))
 

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

problem format or something else ))
 

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


On May 30, 5:58*pm, ytrewq1308
wrote:
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

problem format or something else ))
 

Formula:

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

Kind regards,

Niek Otten
Microsoft MVP - Excel
"ytrewq1308" wrote in message ...
|
| 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

problem format or something else ))
 

=TEXT(B6,"#.0")&"-"&TEXT(B6,"#.0")
--
Wag more, bark less


"ytrewq1308" wrote:


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

problem format or something else ))
 

My first post had two "B"'s the first "B" shouuld be an "A"
--
Wag more, bark less


"ytrewq1308" wrote:


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