Engineering formats for numbers

[neilkeron]

I have been trying for some time to persuade Excel to format numbers in 'engineering' format. ie a pseudo scientific format where the exponent is alway a multiple of three and the number of digits to the left of the decimal point in the significand is adjusted accordingly. It was apparent from previous traffic that a lot of people are not familiar with this but anyone who has a Hewlett Packard calculator will be familiar with it.

Anyway after several days of trying to write my own macro, I have discovered one of the Exxcel custom formats which seems to do the trick. Just choose "##0.0E+0" from the list of custom formats and Excel seems to do what is required.

Regards

Neil Keron

 

[arthurbr]

Welcome to the board.
Glad you found the solution to your problem. In the future don't hesitate to post your questions on this forum . You would have received the answer within minutes.
Cheers

 

[neilkeron]

Engineering format

In fact I did search on this subject some weeks ago and there was no satisfactory solution which is why I posted the solution I came up with.
Regards
Neil Keron

 

[Gates Is Antichrist]

Mr. Excel just did a podcast on this. If you have a mp4 player they're all great.