| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert currency numbers from spreadsheet such as 48 = $48.00
I want to insert spreadsheet fields into a word document. the numbers that i
enter into the spreadsheet might be 48 but I want it to convert to currency, that is $48.00. How do I do that? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert currency numbers from spreadsheet such as 48 = $48.00
Hi Bob,
In word INSERT | OBJECT | EXCEL SPREADSHEET type 48 and just format as currency hope this helps Regards from Brazil Marcelo "Bob" escreveu: I want to insert spreadsheet fields into a word document. the numbers that i enter into the spreadsheet might be 48 but I want it to convert to currency, that is $48.00. How do I do that? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert currency numbers from spreadsheet such as 48 = $48.00
Hi Marcelo,
I tried that but it inserted a table into my word document. I can get the numbers to show the currency amount in the spreadsheet view but when i insert the field into my word document, it only shows the number without the $ sign. Any othe rsuggestions? bob "Marcelo" wrote: Hi Bob, In word INSERT | OBJECT | EXCEL SPREADSHEET type 48 and just format as currency hope this helps Regards from Brazil Marcelo "Bob" escreveu: I want to insert spreadsheet fields into a word document. the numbers that i enter into the spreadsheet might be 48 but I want it to convert to currency, that is $48.00. How do I do that? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert currency numbers from spreadsheet such as 48 = $48.00
did you insert the spreadsheet as an object in word?
if yes, double click on the table (excel) and format as currency, remember that you may chose what currency signal you want. hope this helps regards from Brazil Marcelo "Bob" escreveu: Hi Marcelo, I tried that but it inserted a table into my word document. I can get the numbers to show the currency amount in the spreadsheet view but when i insert the field into my word document, it only shows the number without the $ sign. Any othe rsuggestions? bob "Marcelo" wrote: Hi Bob, In word INSERT | OBJECT | EXCEL SPREADSHEET type 48 and just format as currency hope this helps Regards from Brazil Marcelo "Bob" escreveu: I want to insert spreadsheet fields into a word document. the numbers that i enter into the spreadsheet might be 48 but I want it to convert to currency, that is $48.00. How do I do that? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert currency numbers from spreadsheet such as 48 = $48.00
When I insert spreadsheet as object, the whole spreadsheet is inserted. I
just want the single field to be inserted. I already have the fields inthe spreadsheet in the currency mode but it doesn't go into the word document with the right formatting. ??? Bob "Marcelo" wrote: did you insert the spreadsheet as an object in word? if yes, double click on the table (excel) and format as currency, remember that you may chose what currency signal you want. hope this helps regards from Brazil Marcelo "Bob" escreveu: Hi Marcelo, I tried that but it inserted a table into my word document. I can get the numbers to show the currency amount in the spreadsheet view but when i insert the field into my word document, it only shows the number without the $ sign. Any othe rsuggestions? bob "Marcelo" wrote: Hi Bob, In word INSERT | OBJECT | EXCEL SPREADSHEET type 48 and just format as currency hope this helps Regards from Brazil Marcelo "Bob" escreveu: I want to insert spreadsheet fields into a word document. the numbers that i enter into the spreadsheet might be 48 but I want it to convert to currency, that is $48.00. How do I do that? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert currency numbers from spreadsheet such as 48 = $48.00
Bob, why not insert a new spreadsheet (empty) type the number and format,
sorry the insistence but its work here. regards "Bob" escreveu: When I insert spreadsheet as object, the whole spreadsheet is inserted. I just want the single field to be inserted. I already have the fields inthe spreadsheet in the currency mode but it doesn't go into the word document with the right formatting. ??? Bob "Marcelo" wrote: did you insert the spreadsheet as an object in word? if yes, double click on the table (excel) and format as currency, remember that you may chose what currency signal you want. hope this helps regards from Brazil Marcelo "Bob" escreveu: Hi Marcelo, I tried that but it inserted a table into my word document. I can get the numbers to show the currency amount in the spreadsheet view but when i insert the field into my word document, it only shows the number without the $ sign. Any othe rsuggestions? bob "Marcelo" wrote: Hi Bob, In word INSERT | OBJECT | EXCEL SPREADSHEET type 48 and just format as currency hope this helps Regards from Brazil Marcelo "Bob" escreveu: I want to insert spreadsheet fields into a word document. the numbers that i enter into the spreadsheet might be 48 but I want it to convert to currency, that is $48.00. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to insert dashes in a column of numbers | New Users to Excel | |||
| How do I insert a 2-3 page Excel spreadsheet as an object in MS Wo | Excel Discussion (Misc queries) | |||
| Can I insert an email into an excel spreadsheet? | Excel Worksheet Functions | |||
| Why does a spreadsheet sent in Excel round numbers when mailed? | New Users to Excel | |||
| How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
Linear Mode
