Cell format newbie query

  • Thread starter Thread starter Brian Tozer
  • Start date Start date
B

Brian Tozer

I have a worksheet where all the cells in a column are formatted as text but
there are numbers entered in the column.
Changing the format of the column, or even any individual cell, to number,
does not remove the triangle in the cell top left corner.
What should I be doing to fix the situation?
Thanks
Brian Tozer
 
Hi Brian!

One quick way:

Select a blank cell
Copy
Select the range with data in it
Edit > Paste Special
Add
OK

You'll note that this converts the format of the selected range to
General


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks very much Norman.
Brian

Norman said:
Hi Brian!

One quick way:

Select a blank cell
Copy
Select the range with data in it
Edit > Paste Special
Add
OK

You'll note that this converts the format of the selected range to
General
Click to expand...
 
Hi Brian!

Thanks for thanks. It shows searchers that something works.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
As my subject indicates I am a newbie.
I am struggling with the basics, but hanging in there.
Thanks for the reply but could someone please give the few extra
instructions on how to implement this gem.
Some questions to indicate my confusion:-

Do I enter this macro into a Worksheet Module, or a Regular Code Module, or
somewhere/somehow else?
Do I invoke/run/call/? it just once or not at all or what?
How do I do this?
Do I need to add anything to the macro to define its area of activity?
Is the quoted macro exactly and totally what I enter or is something extra
implicit in the text?

I hope this helps someone to be able to help me with this typical example
that will hopefully clarify a far wider field of interest.

Thanks
Brian Tozer
 
Back
Top