Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good morning,
I am using Excel to write checks because the checks are for Peachtree accounting and we are using Quickbooks. I want to minimize errors. Can I type a number in a cell and have it translated into text on another cell. for exam $5.00 would be translated into "five dollars and 0 cents." That would really be helpful to me if anyone could help. Thanks. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Take a look at the UDF here
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- __________________________________ HTH Bob "Gmax" wrote in message ... Good morning, I am using Excel to write checks because the checks are for Peachtree accounting and we are using Quickbooks. I want to minimize errors. Can I type a number in a cell and have it translated into text on another cell. for exam $5.00 would be translated into "five dollars and 0 cents." That would really be helpful to me if anyone could help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
translated menu in excel 2007 | Excel Discussion (Misc queries) | |||
how to convert date type to text type | Excel Discussion (Misc queries) | |||
Adding new 'Type' to Format->Number->Time->Type | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |