Add letter before a number in a cell

[Johnboy]

Hi All

I am trying to add a letter before a set of numbers in a cell. I have seen this before at Chandoo but cant seem to find it anymore. This site rocks and I have been using it for some time.

 

[Smallman]

Hi Johnboy

By letter do you mean you want to Concatenate data.

="A"&A2

Where A2 is a value. Or do you mean you want to use the Format to precede a number with a letter. Format Cells - Custom format;

A 0.00

Let the group know.

Smallman

 

[Johnboy]

Hi Smallman

I have columns filled with numbers that I want to include the letter "E" in the front of the numbers.

Thanks

 

[sudipto3003]

Hi johnboy,

select the cells you want to format, next go to format cell, number, custom, in the type box write "E"0, then ok.

regards
sudipta

 

[Johnboy]

Hi Sudipto3003

That works a treat, thanks for your help

 

[sudipto3003]

you are welcome