| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| General Format to Custom format problem | Excel Discussion (Misc queries) | |||
| if format problem | Excel Worksheet Functions | |||
| Format Problem | Excel Discussion (Misc queries) | |||
| Format problem | Excel Discussion (Misc queries) | |||
| Problem with txt format | Excel Discussion (Misc queries) | |||
Hybrid Mode
