Remove a character from a number field
 

Im working with a column of various hh:mm data. Example of data:

29.28h
344.25h
26.75h
7.25h
0h
12.5h
0h
14.5h
13.25h

As you can see, there is no fixed decimal place. Does any one know how I may
be able to move the €˜h from the end of the numbers for the column?

Thanks in advance,

Remove a character from a number field
 

Try this and drag down

=LEFT(A1,LEN(A1)-1)*1

Mike

"Taj" wrote:

Im working with a column of various hh:mm data. Example of data:

29.28h
344.25h
26.75h
7.25h
0h
12.5h
0h
14.5h
13.25h

As you can see, there is no fixed decimal place. Does any one know how I may
be able to move the €˜h from the end of the numbers for the column?

Thanks in advance,

Remove a character from a number field
 

hi
the simplest and easiest way might be to use find and replace.
high light the column then ctrl+F
click the replace tab
find what:= h
replace with:= leave blank
click replace all

regards
FSt1


"Taj" wrote:

Im working with a column of various hh:mm data. Example of data:

29.28h
344.25h
26.75h
7.25h
0h
12.5h
0h
14.5h
13.25h

As you can see, there is no fixed decimal place. Does any one know how I may
be able to move the €˜h from the end of the numbers for the column?

Thanks in advance,

Remove a character from a number field
 

Edit/ replace/ h/ with /(nothing)
--
David Biddulph

"Taj" wrote in message
...
I'm working with a column of various hh:mm data. Example of data:

29.28h
344.25h
26.75h
7.25h
0h
12.5h
0h
14.5h
13.25h

As you can see, there is no fixed decimal place. Does any one know how I
may
be able to move the 'h' from the end of the numbers for the column?

Thanks in advance,

Remove a character from a number field
 

Hey thanks guys, you've saved me a great deal of time




"David Biddulph" wrote:

Edit/ replace/ h/ with /(nothing)
--
David Biddulph

"Taj" wrote in message
...
I'm working with a column of various hh:mm data. Example of data:

29.28h
344.25h
26.75h
7.25h
0h
12.5h
0h
14.5h
13.25h

As you can see, there is no fixed decimal place. Does any one know how I
may
be able to move the 'h' from the end of the numbers for the column?

Thanks in advance,