formatting issue

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

I have a colume within which is entered chemical concentrations in either :

Molarity - thus 1.6M
Concentration - thus 50%

The column is formatted as a % so that the concentartion number come out
correct, however i find that the molarity data is formatted as 1.6M% ???

I dont want the % at the end of the molarity.

Can anyone help?

Thanks,

Roger
 
A cell can only have one format. You can set it to no format, then as you
enter a number requiring a percent, you can press the % icon.
 
You must log in or register to reply here.

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

Convert 2
formatting textboxes 1
synonyms - need help with vlookup 6
Error message when searching for an item not in a listbox 1
listbox -shows table of information - option to select and edit ro 2
Comments - populate using vlookup 2
Automating a simple multiplication to a reference cell 1
Changing number format to remove % 2

Back
Top