| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Number and Word in the same cell
Perhaps =IF(MOD(A1,1)<0,TEXT(A1,"0000.00")&" metres",TEXT(A1,"0000")&"/= metres") will suit your needs, but the question does seem to have drifted a little from metres to cents. nowfal Wrote: Hi Ragdyer, Thanks for reply. I also thinking that way. Hope somebody will have some new tricks. nowfal -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=477776 |
|
#2
|
|||
|
|||
|
Number and Word in the same cell
Yes, exactly right formula. This is why this forum seems to be the best. thanks to Bryan Hessey, and all those help early. the corrected formula is as =IF(MOD(a1,1)<0,TEXT(a1,"0.00")&" ",TEXT(a1,"0")&"/= ") thanks and regards nowfal -- nowfal ------------------------------------------------------------------------ nowfal's Profile: http://www.excelforum.com/member.php...o&userid=10003 View this thread: http://www.excelforum.com/showthread...hreadid=477776 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number in cell convert in word | Excel Worksheet Functions | |||
| Max number if characters in a merged cell | Excel Discussion (Misc queries) | |||
| How do I link a certain number to a certain word? | Excel Worksheet Functions | |||
| copy a number typed in a cell to another & change it to word form. | Excel Discussion (Misc queries) | |||
| Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
Hybrid Mode
