General discussion

Locked

Advanced formatting in Excel

By Pugwash_z ·
In the article "10 advanced formatting tricks for Excel users", which was very informative, I have one point to raise.
Churchill said that the USA and the UK were two nations divided by a common tongue.
Item 4 says "The pound sign combined with the two comma characters displays a character in the millions position, if one exists." In the UK the pound sign is our currency symbol, which, if used as per the example, would not work. We prefer to call that symbol the hash sign.
I once worked on a system that was to be hosted on two main-frames, one on each side of the Atlantic. When I spoke of "scrubbing" data, i.e. cleaning it up to get commonality across the "pond", my American colleagues promptly deleted it.

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Tips and Tricks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums