Thread
:
convert text to dollar
View Single Post
#
2
Posted to microsoft.public.excel.misc
Pete_UK
external usenet poster
Posts: 8,856
convert text to dollar
Just divide the number by 100, eg:
=A1/100
if your value is in A1.
Hope this helps.
Pete
julz wrote:
How do I convert a text number to dollar amount ?
Example :
711 to 7.11
17263 to 172.63
Reply With Quote
Pete_UK
View Public Profile
Find all posts by Pete_UK