Trouble Combining Cell Values

[CCSLBuckles]

Hey folks,

I have two cells that need combining: D1 and C1 in that order - (because it look prettier than C1 & D1 and I can't be bothered to redo my formula table)

I have used the formula in E1: =D1&" "&C1 and yes it works, but I've lost my decimal formatting from C1. How do I retain this?

eg. it comes out as -- 02:00:09:08 14 and I want it to come out as 02:00:09:08 14.00

(Decimal formula is 0.00 I think...)

Thanks!

BONUS QUESTION!

Is there a way to separate the two values with a paragraph mark? I have it set to a space and then find/replace in Word later - but separating by a paragraph mark will save me a step of my working order.

Bonus thanks!

[Richard Buttrey]

Hi,

We could do with seeing the workbook, but assuming C1 contains the value 14 then use &TEXT(C1,"0.00")

Instead of inserting the space then use &CHAR(182)

[CCSLBuckles]

That worked. Huzzah for the internet. Thanks.

The &CHAR(182) didn't work, it just put &CHAR(182) in my line:

02:00:09:08&CHAR(182)14.00

Working formula atm ==D1&" "&TEXT(C1,"0.00")

[CCSLBuckles]

Deleted: Double post.