Sorry if this has been answered before. I did a search and couldn't find anything.
I have a column of numbers which is stored as text.
I can convert them to number but need to keep all the preceding zeros eg 01823. When I convert, I lose the zero.
Is there a way around this?
Thanks in advance.
Rob
Hi,
I'm looking for some code to convert numbers stored as text to numbers.
Can anyone help me with this please?
Thanks
How can I format a column of numbers as text other than:
1. Format Cells... select "Text" on the number tab
2. Create a column with the apostrophe, and use CONCATENATE function
3. Use TEXT function or any other type of function
4. Macros
Is there a fast and simple way to do this if I need to do it on a daily basis?
Hi guys,
I scraped some datas from a web site and convert those datas into excel template. I took the datas from that web site. Its format like this "01.40.20" the first term represents minute the second term represents second and the third term represents millisecond. However this is on text format now. It is not number. I want to sum another time and show the result again on this format. What is your suggestions ?
Thanks
Hi all,
I my excel file B2:B XXX
but it is in Text format. i want to convert the same in Number format.
Please help to provide VBA Code.
Thank you !!!!
I have a check box that is either TRUE or FALSE, and this value is displayed in a cell.
What I would like to do is that convert TRUE to 1 and FALSE to 0 and have this value display in the cell instead. Is there a way to convert the TRUE and FALSE to numbers?
This may be an easy question (and obviously I know taht I can use another cell and use an IF statement to convert - I want to save thsi step)
Thanks.
how to :-
100 convert to One Hundred only
and
100.30 convert to One Hundred and 30 Cent only
I want to convert a text to number.
Say if a cell contains "ABCD PRIVATE LIMITED"
I want get the first word converted to a predictable number.
Can someone help.
Mohan Dhingra
