After researching various solutions I can not figure out why one cell will not format to a currency and another will. There are no formulas in the attached example because I only pasted Values in the sheet. What am I doing Wrong? I'm also not sure if i attached the sheet correctly. Thanks
Excel Help.xls
Because it's text; you can tell because it's left justified.
It has a trailing space.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Ahhh!
Ok, How do i convert to a number?
Delete the trailing space.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
Awesome that worked! Now is there a formula to do that because i have about 2000 lines to do?
Select the column then find and replace space with nothing.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks