Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can someone suggets how to concatenate
50.0 50.1 50.2 into 50.0 - 50.1 - 50.2 That is the number (with one decimal place) followed by a SPACE HYPHEN SPACE second number with one decimal place...etc Everything I try omits the ".0" if it happens to be a zero. I also have some cells that require 2 decimal places and may end in two zeros....I would like those to have the same format....number space hyphen space number. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format Concatenate function? | Excel Discussion (Misc queries) | |||
CONCATENATE And Date Format | Excel Discussion (Misc queries) | |||
Vlookup, Concatenate, Format | Excel Discussion (Misc queries) | |||
Format numbers / Concatenate | Excel Discussion (Misc queries) | |||
concatenate and format | Excel Worksheet Functions |