Excel 2007 : Help with Custom Function that will auto add "MPH" after number I type

[Big O]

After some frustration in the office and some browsing of the web including this forum I am at a loss on how to achieve a format that will allow me to enter a value and have it auto formatted for MPH (amongst other descriptors).

I have a simple spreadsheet for my construction project that details the days activities and weather conditions. I have created custom function to add the degree symbol after the temperature but am failing at having the MPG and IN added after wind speed and precipitation.

Any ideas?

TIA

[Ron Coderre]

Can you post some of the formulas you've tried...even if they don't work...so we'll have a better understanding of what you're working with?

[Big O]

Absolutely.

I started with 00 MPH and a pop up error message stating "Microsoft Office Excel cannot use the number format you typed. Try using one of the built-in number formats. For more information ......"



## MPH
#, ##; MPH
#, ## MPH
## "MPH"

none of those error'd nor worked.

[Ron Coderre]

Try this custom number format:
0 \M\P\H

The backslashes cause the following character to be displayed literally and not interpreted...(otherwise, M would be treated as a month, H as an hour, etc)

Does that help?

[Big O]

Very nice ... thanks Ron. I just read about that for the first time this morning but didn't know it applied to text also. The instance I read about was applied to decimal symbol and use the slash to do a literal instead of interpret.

Thanks again!