Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dollars to text without loosing zeros from decimal places
I need to convert dollars to text but the decimal place digits must remain
since this will be converted to a txt file for file transfers. When I convert $19,500.00 to text it becomes 19500 but I need the zeros from the decimal places. Your help is truly appreciated. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dollars to text without loosing zeros from decimal places
=TEXT(A1,"0.00") or =TEXT(A1,"$#.00"), depending on whether or not you want
the $ symbol. -- David Biddulph "DOK" wrote in message ... I need to convert dollars to text but the decimal place digits must remain since this will be converted to a txt file for file transfers. When I convert $19,500.00 to text it becomes 19500 but I need the zeros from the decimal places. Your help is truly appreciated. Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dollars to text without loosing zeros from decimal places
Use a help column and text function
=TEXT(A1,"$#,##0.00") copy down as long as needed, then copy and paste special in place, then export the help column or just copy and paste over the old data -- Regards, Peo Sjoblom "DOK" wrote in message ... I need to convert dollars to text but the decimal place digits must remain since this will be converted to a txt file for file transfers. When I convert $19,500.00 to text it becomes 19500 but I need the zeros from the decimal places. Your help is truly appreciated. Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dollars to text without loosing zeros from decimal places
Thank you but this still gives me a decimal point which must be removed or it
rounds up to the next whole number. "David Biddulph" wrote: =TEXT(A1,"0.00") or =TEXT(A1,"$#.00"), depending on whether or not you want the $ symbol. -- David Biddulph "DOK" wrote in message ... I need to convert dollars to text but the decimal place digits must remain since this will be converted to a txt file for file transfers. When I convert $19,500.00 to text it becomes 19500 but I need the zeros from the decimal places. Your help is truly appreciated. Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dollars to text without loosing zeros from decimal places
Where did you state that the decimal point must be removed in your original
post? You only said you wanted the decimals to remain? Just multiply with 100, then copy and paste special as values, then format as text. -- Regards, Peo Sjoblom "DOK" wrote in message ... Thank you but this still gives me a decimal point which must be removed or it rounds up to the next whole number. "David Biddulph" wrote: =TEXT(A1,"0.00") or =TEXT(A1,"$#.00"), depending on whether or not you want the $ symbol. -- David Biddulph "DOK" wrote in message ... I need to convert dollars to text but the decimal place digits must remain since this will be converted to a txt file for file transfers. When I convert $19,500.00 to text it becomes 19500 but I need the zeros from the decimal places. Your help is truly appreciated. Thank you |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dollars to text without loosing zeros from decimal places
=TEXT(A1,"00")*100
Gord Dibben MS Excel MVP On Thu, 13 Dec 2007 08:52:02 -0800, DOK wrote: I need to convert dollars to text but the decimal place digits must remain since this will be converted to a txt file for file transfers. When I convert $19,500.00 to text it becomes 19500 but I need the zeros from the decimal places. Your help is truly appreciated. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Insert Decimal Places and Clear Zeros | Excel Discussion (Misc queries) | |||
Setting the number of decimal places for a text box. | Excel Discussion (Misc queries) | |||
number returns only two decimal places after I change from text | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |