james

Posts: n/a

converting from text to numerical number

I have a spread sheet of entire year schedule. The format as following:

1 2 3 .... 31
row 1
row 2
row 3 Jan
row 4
row 5 Feb

row x Dec

I would like to replace column 1 up to Jan to 1. Replace the cell below Jan
to Feb to 2. etc.

Would anyone help.

Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
roundoff when converting text to numbers	Jack	Excel Worksheet Functions	3	January 30th 05 01:51 AM
Converting text to a number	Helen Black	Excel Worksheet Functions	0	January 19th 05 01:33 PM
Converting text to a number	Helen Black	Excel Worksheet Functions	1	January 18th 05 04:08 PM
Converting text to number - how??	yahoo	Excel Discussion (Misc queries)	3	December 15th 04 11:01 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 08:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us