Text in Excel

[jthamizhirai]

dear all

can anyone please help me with this problem?

how to enter numbers as text straight away in excel.

currently i input the number and use the formula

=text(a1,"#")to convert the number to text.

i want to enter the number straight as text.

thanks in advance.

jay

 

[Faseeh]

Hi jthamizhirai,


Select the cell and right click, select Format Cells and select Text, Press OK. you will be entering your no. as text.


Regards,

Faseeh

 

[senthilkumar_rm]

Hello,


Why to use a formula, Select the range of cells where you want to enter number as text and right click | Format cells |(Short cut Ctrl +1)| Number tab | Category -> Select Text

Now, You can enter any number it gives u text format


Senthilkumar_rm

 

[oldchippy]

Hi,


Another quick way is to proceed the number with a single quote mark first, that will format it to text


eg: '123

 

[jthamizhirai]

thanks a lot to fashee,senthil and old chippy

if we have used a single quotation mark and entered the number

how do we take away the single quotation mark which appears before the number

 

[senthilkumar_rm]

Hi Jthami,


Select all the cells which has 'and you will find auto fill option, click convert to number


If u dont understand please post

 

[oldchippy]

Hi,


Of course if its a single cell, then you could edit in the formula bar. But either using this or senthilkumar_rm's suggestion will convert the text entries back to numbers.


Although you can see the single quote in the formula bar for a selected cell, they do not show in any of the cells on the worksheet

 

[jthamizhirai]

thanks all will try and post

jay