| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
appended a cell, but need to keep decimal places
hi,
in cell a1, i have 720.00 and i need to make it "720.00" (basically adding quotes around it). i'm using the following formula =""""&a1&"""" and i'm getting "720" which is almost there, but i need the two decimals. if in cell b1 i have 720.25 and i use the formula above, i get "720.25" which is great... any thoughts on me losing the trailing zeros in the first example? thank you for your help!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
appended a cell, but need to keep decimal places
=""""&TEXT(A1,"#,##0.00")&""""
Gord Dibben MS Excel MVP On 11 Apr 2007 14:12:12 -0700, wrote: hi, in cell a1, i have 720.00 and i need to make it "720.00" (basically adding quotes around it). i'm using the following formula =""""&a1&"""" and i'm getting "720" which is almost there, but i need the two decimals. if in cell b1 i have 720.25 and i use the formula above, i get "720.25" which is great... any thoughts on me losing the trailing zeros in the first example? thank you for your help!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
appended a cell, but need to keep decimal places
=""""&TEXT(a1,"0.00")&""""
-- David Biddulph wrote in message oups.com... hi, in cell a1, i have 720.00 and i need to make it "720.00" (basically adding quotes around it). i'm using the following formula =""""&a1&"""" and i'm getting "720" which is almost there, but i need the two decimals. if in cell b1 i have 720.25 and i use the formula above, i get "720.25" which is great... any thoughts on me losing the trailing zeros in the first example? thank you for your help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal places in format cell | Excel Discussion (Misc queries) | |||
| cell formated to 2 decimal places but excel shows it as 4 need 2 | Excel Worksheet Functions | |||
| How many decimal places can a cell display? | Excel Worksheet Functions | |||
| how to count the number of decimal places in a cell? | Excel Worksheet Functions | |||
| How do I insert 2 decimal places to a number in cell? | Excel Worksheet Functions | |||
Hybrid Mode
