Simple decimal points question - **Pls Help**

jillian728

Board Regular
Joined
Jun 20, 2003
Messages
243
In Excel, I have a column of data that displays only 2 decimals.

However, when I merge that column of data into a Word doc using Mail Merge, it shows up with ~7 decimals.

In Excel, I formatted the column to be text and display only 2 decimals. However, it still shows up with ~7 decimals.

I have a deadline to send this merged data before I fall asleep tonight.

Please help! I'm sure that this is a simple fix.
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

jillian728

Board Regular
Joined
Jun 20, 2003
Messages
243
I figured it out. It was simple:

I used the following formula: =FIXED(N2,2)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,095
Messages
5,545,923
Members
410,713
Latest member
TaremyLunsil
Top