Thread: to make the digit 10 into the text ten
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default to make the digit 10 into the text ten
You can do this without changing the programming.

With 10 in A1 and ten in B1 enter in C1:
=B1 & " dollars and cents"
--
Gary''s Student - gsnu200826


"Tbarbee708" wrote:

Gary, 1 last thing, it is putting in the words"dollars and cents" behind the
ten how can I get it to not include any other words except the digit ?
thank you
--
Tbarbee708


"Gary''s Student" wrote:

http://support.microsoft.com/default...EN-US;Q213360&
--
Gary''s Student - gsnu200826


"Tbarbee708" wrote:

can i type in a numer (ie 10) in A1 and have A2 fill in automatically the
written "ten"? etc
--
Tbarbee708
Reply With QuoteReply With Quote