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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

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,118,417
Messages
5,571,982
Members
412,430
Latest member
Huuktkt
Top