Format General Number to Currency

anctech · Feb 18th, 2002, 01:11 PM

How can I format a General Number that was imported from a text file. The numbers are showing up with no decimal points. For example, a number that was imporated is shown as 40000 but should be displayed as 400.00

Is there a quick format to insert the decimal place into the correct area of the number.

Thank You to anyone who can help with this problem I am having.

[ This Message was edited by: anctech on 2002-02-18 12:52 ]

Juan Pablo González · Feb 18th, 2002, 01:53 PM

Put 100 in an empty cell, copy it, select the cells you want to change, go to Edit, Paste Special, select Values and Divide and click Ok. Now you can format as Number with 2 decimals.

anctech · Feb 18th, 2002, 02:10 PM

Thank You very much Juan Pablo G. That soluction worked great.

Your help with this is very much appreciated.

Feb 18th, 2002, 01:53 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Put 100 in an empty cell, copy it, select the cells you want to change, go to Edit, Paste Special, select Values and Divide and click Ok. Now you can format as Number with 2 decimals. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 01:11 PM	#1
anctech New Member Join Date: Feb 2002 Posts: 2	How can I format a General Number that was imported from a text file. The numbers are showing up with no decimal points. For example, a number that was imporated is shown as 40000 but should be displayed as 400.00 Is there a quick format to insert the decimal place into the correct area of the number. Thank You to anyone who can help with this problem I am having. [ This Message was edited by: anctech on 2002-02-18 12:52 ]

Feb 18th, 2002, 02:10 PM	#3
anctech New Member Join Date: Feb 2002 Posts: 2	Thank You very much Juan Pablo G. That soluction worked great. Your help with this is very much appreciated.