Currency Field

rjacmuto32

Board Regular
Joined
Jul 14, 2004
Messages
98
I have a text file with a long sting of text and numbers together. I brought that into excel and did a left formula to get me the 8 places that contain my dollar amount. The problem is the amounts have no decimal places in them. For example 00015825 I want to display it with a decimal. The last 2 digits are the decimal. so i want excel to display 158.25 How do I do that?
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:

You might try custom the formatting features forund in Format \ Cells \ Custom


look at the samples provided and modify as needed..


Also consider dividing the cell contents by 100 ie =+G12/100


plettieri
 

Watch MrExcel Video

Forum statistics

Threads
1,114,384
Messages
5,547,638
Members
410,805
Latest member
Ginoji
Top