Problem formatting cells as currency

L

Laura G

I am having a problem formatting cells to currency for
data that was imported into Excel from a text file. It
was imported in the format 49420. 8 but will not accept
any formatting. Does anyone know how to correct this?
 
K

Ken Wright

The data is most likely in text format and will therefore not accept any
formatting. Copy an empty cell, select all your data and then do Edit / Paste
Special / Add.

If this doesn't fix it then you probably have garbage characters in there.
These can be removed by running Dave McRitchies Trimall macro - Then do the
routine above if data is not as you want.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Auto copying text 0
Paste to excel from word - auto format problem 1
Converting URLs in comments to Markdown-formatted links 2
Printing Outline view - formatting lost 0
Convert number to text as displayed 4
Change a great number of words in word files, with a macro as short as possible. 5
Currency autofit 5

Top