I am using a mix of text and a formula to draw a number from another sheet

i.e. ="The average mark for the presentation was " & data!B282

B282 is the calculated figure on a scond sheet.

However, althought the imported number shows on the original page as '1.3'
for example, it imports the number showing it to about 12 decimal places. Is
there any way I can reduce that to 1 or 2 decimal places?

Thanks

Alec

Thanks

="The average mark for the presentation was " & TEXT(data!B282,"#,##0.0")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mcgrape" wrote in message
...
I am using a mix of text and a formula to draw a number from another sheet

i.e. ="The average mark for the presentation was " & data!B282

B282 is the calculated figure on a scond sheet.

However, althought the imported number shows on the original page as '1.3'
for example, it imports the number showing it to about 12 decimal places.
Is
there any way I can reduce that to 1 or 2 decimal places?

Thanks

Alec

Thanks

Try:
="The average mark for the presentation was " & TEXT(data!B282,"0.0")

--
Gary''s Student - gsnu200795


"mcgrape" wrote:

I am using a mix of text and a formula to draw a number from another sheet

i.e. ="The average mark for the presentation was " & data!B282

B282 is the calculated figure on a scond sheet.

However, althought the imported number shows on the original page as '1.3'
for example, it imports the number showing it to about 12 decimal places. Is
there any way I can reduce that to 1 or 2 decimal places?

Thanks

Alec

Thanks

Use

="The average mark for the presentation was " & fixed(data!B282,2)



"Gary''s Student" wrote:

Try:
="The average mark for the presentation was " & TEXT(data!B282,"0.0")

--
Gary''s Student - gsnu200795


"mcgrape" wrote:

I am using a mix of text and a formula to draw a number from another sheet

i.e. ="The average mark for the presentation was " & data!B282

B282 is the calculated figure on a scond sheet.

However, althought the imported number shows on the original page as '1.3'
for example, it imports the number showing it to about 12 decimal places. Is
there any way I can reduce that to 1 or 2 decimal places?

Thanks

Alec

Thanks

Clever solution..........FIXED instead of TEXT and format


Gord Dibben MS Excel MVP

On Wed, 16 Jul 2008 04:29:00 -0700, sacrame
wrote:

Use

="The average mark for the presentation was " & fixed(data!B282,2)



"Gary''s Student" wrote:

Try:
="The average mark for the presentation was " & TEXT(data!B282,"0.0")

--
Gary''s Student - gsnu200795


"mcgrape" wrote:

I am using a mix of text and a formula to draw a number from another sheet

i.e. ="The average mark for the presentation was " & data!B282

B282 is the calculated figure on a scond sheet.

However, althought the imported number shows on the original page as '1.3'
for example, it imports the number showing it to about 12 decimal places. Is
there any way I can reduce that to 1 or 2 decimal places?

Thanks

Alec

Thanks