View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
m4d Ir15h[_2_] m4d Ir15h[_2_] is offline
external usenet poster
 
Posts: 10
Default Data to a simple paragraph.

thank you pete... with the code you gave me, I was able to figure it out.

This is going to save me A LOT of time...

"Pete_UK" wrote:

What kind of paragraph are you talking about, and how will Excel know
what words to use?

If it is something like "This week's total is xxx.x" and you want
Excel to calculate the "xxx.x", then you can do this in a cell, with
the calculated value in A1:

="This week's total is "&TEXT(A1,"000.0")

Hope this helps.

Pete

On Jul 8, 4:22 pm, m4d Ir15h <m4d
wrote:
Hello, I work in an office where I do a lot of data entry. I recently
received a mess load of work to do where the data has to be calculated,
processed and recorded into Excel and then has to be put into a paragraph
form and recorded in a separate database.
Unfortunately, for the amount of work it requires, it takes a lot of time.
Is there a way that I can enter in the figures so that excel does the math
for me and then places it in the text paragraph that I would use via 'Cut and
Paste' for the alternate database?

and if there is, what exactly am I looking for...? Is it a script...?
Macro...?