Number Format

[sdsurzh]

Hi,


Suppose i have a set of number

1.100

1.208

1.098

and i want to add text " done" to the list with extact value like

1.100 done

1.208 done

1.098 done


How it can be combined using formula.


Thanks,

Suresh Kumar S

 

[shrivallabha]

Assuming you have data in A2

=A2&" done"

and then copy down.


Does this help?

 

[sdsurzh]

Hi Shri,


For 1.208 & 1.098 it will work but for 1.100 it shows "1.1 done" but i want "1.100 done" and it will work if we change the format to text for 1.100 cell.


Thanks,

Suresh Kumar S

 

[shrivallabha]

Hi Suresh Kumar,


Perhaps then:

=TEXT(A1,"0.000")&" done"

 

[sdsurzh]

Thanks buddy

 

[Hui]

Suresh


You can also apply a Custom Number format of 0.000 "Done"

 

[oldchippy]

Hi Suresh,


By using Hui's suggestion you can also total the numbers with the previous one's you can't as they are text values

 

[sdsurzh]

Thanks Hui & Oldchippy