Discussion Locked

Advanced formatting in Excel

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.